Reports: Access97

[Lumpierbritches]

Thank you in advance for any and all assistance. I'm trying to create a report
that will work similar to the label wizard in Access. I have a premade form I'm
attempting to fill with data from the db. I can manually make the information
fit, by making the report the full 8.5" x 11", however, when I attempt to size
the report so that an individual record prints in each one, the sizing is all
off. Is there a secret for dividing up the report page with .50 footer and .50
header with .25 and .251 repspectively right and left margins to get say
"three" (3) even records?

Also, does each record require the .50 header and footer to computated for
spacing also? If that's the case, you loose 3" in an 11" form????

Michael

[Wayne Gillespie]

On 04 Dec 2004 16:52:35 GMT, lu*************@aol.com (Lumpierbritches)
wrote:

Thank you in advance for any and all assistance. I'm trying to create a report
that will work similar to the label wizard in Access. I have a premade form I'm
attempting to fill with data from the db. I can manually make the information
fit, by making the report the full 8.5" x 11", however, when I attempt to size
the report so that an individual record prints in each one, the sizing is all
off. Is there a secret for dividing up the report page with .50 footer and .50
header with .25 and .251 repspectively right and left margins to get say
"three" (3) even records?

Also, does each record require the .50 header and footer to computated for
spacing also? If that's the case, you loose 3" in an 11" form????

Michael

Open the report in design view,. From the file menu select Page Setup
and then click on the Columns tab. Here you will be able to set the
margins etc for multi column reports.
Wayne Gillespie
Gosford NSW Australia

[Lumpierbritches]

Thank you for your reply. I have tried with the column setup and still no
success. Any assistance with this matter will be greatly appreciated.

I have a form with three up on a page preprinted and Iwant to fill in this form
with my data. The records are NOT lining up. I have measure with a ruler and
can manually make a report that will fill in all the fields on the form, with
ONE record. I wish to fill in the form with different records.

The sizing for some reason makes the first record fit, but subsequent records
are off by nearly an inch or more. This is my dilema.

CC: Newgroup

Michael

[Wayne Gillespie]

On 05 Dec 2004 01:31:43 GMT, lu*************@aol.com (Lumpierbritches)
wrote:

Thank you for your reply. I have tried with the column setup and still no
success. Any assistance with this matter will be greatly appreciated.

I have a form with three up on a page preprinted and Iwant to fill in this form
with my data. The records are NOT lining up. I have measure with a ruler and
can manually make a report that will fill in all the fields on the form, with
ONE record. I wish to fill in the form with different records.

The sizing for some reason makes the first record fit, but subsequent records
are off by nearly an inch or more. This is my dilema.

CC: Newgroup

Michael

If you need to print 3 records per page on a pre-printed form, then
columns are not the answer.
Printing to a pre-printed form is usually a royal PITA.

You need to set the height of the detail section of the report to the
exact height of a SINGLE record on the pre-printed form. If your form
has 3 records per page (assuming A4), the detail section will be
around 3 - 3.5 inches in height.
Turn off headers and footers so that the detail section is the only
section in the report. Set your controls within the detail section to
match a single record on the pre-printed form.

When you preview the report 3 records should be printed per page with
each record immediately following the next. You then need to adjust
your top and bottom margins to line up with the pre-printed form.

HTH

Wayne Gillespie
Gosford NSW Australia