More than 1 page of data...

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Does anyone understand why Access creates, or prints, 5
copies of the data when the data goes over one page?

I have created reports, forms, and have tried to print
the information, but when the data goes beyond one page
of information, it creates 5 copies with a blank page in
between each copy.

This one has me completely confused. Anyone have an
answer?

Scott
 
If you are getting blank pages in a report, you have made the report wider than your piece of paper less the margins.

By default, Access sets the margins at 1".

You have several options:

Narrow your report in design view so that it's width plus the margins is less than your paper width
Lower the margins - File/Page Setup
Change the paper from portrait to landscape - Also File/Page Setup
Change the paper to legal size - Also File/Page Setup

Or any combination of the above so that your report width plus the margins is less than you paper width.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Scott said:
Does anyone understand why Access creates, or prints, 5
copies of the data when the data goes over one page?

I have created reports, forms, and have tried to print
the information, but when the data goes beyond one page
of information, it creates 5 copies with a blank page in
between each copy.

This one has me completely confused. Anyone have an
answer?

Scott
Click to expand...

I am not sure exactly what is happing for you, but many people have
problems with blank pages because they format a report too wide with
something going beyond the printable area of the page. This printable area
is different for different printers. Often the object is not visible so you
don't see it in design mode.

For this make sure you allow for printable area and margins and check
for anything beyond that area (try "select all" to highlight items that you
might not otherwise see.

Also make sure you have the current printer drivers for your printer and
you know what the printable area is for that driver and printer.

Large headers and or footers can cause problems as well.
 
Back
Top