Large number of controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that follows this process: the user prints a form
(datasheet) to fill out data, enters the data into a data-entry form, prints
out another form (proofing sheet) to proofread the data, then prints a final
report that includes calculations using the data.

My question: Is there a better way to create the datasheet than using MANY
boxes? I have a header and then in the detail section as many boxes as will
fit under the headings. The report can be landscape or portrait. Sometimes
that's a lot of boxes! Is there a better way to create such a form? I don't
really want to create it in Excel or Word but I suppose I could do that.....

Thanks in advance.
 
If I knew Susy ........ oops sorry wrong newsgroup!

Create a table with the numbers 1 to the max rows you need. Create a table
with the number of fields you need to give you the number of columns in the
datasheet. No records in this table. Create a query that includes both
tables. There will be no join lines between the tables. Only include the
fields from the second table; do not include the number field. Create a
continuous report from the query making sure the Border property is set to
solid for each field.
 
Funn-nny!! oops, I mean sorr-rry; I made a mistake.

Scratch "No records in this table."; you need one record in the second
table. Put "A" in each field in the record. Use the report wizard to create
the report based on the query and only include the fields from the second
table. Open the report in design view and delete the control source for each
field.

Steve
PC Datasheet
 
Back
Top