Report Page Length Limitation

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

Guest

Here is the problem:
I have a VBA routine in a module that creates separate queries and then makes calculations. The results are sent to a report via the Report_Open and Detail_Print events. I am able to create 5 pages but I need at least 7. I use page breaks in the detail section to create the pages. Every page has different information. Any suggestions as to how I can increase the report page length? Or, is there a better way of doing what I want to do?
 
JimD said:
I have a VBA routine in a module that creates separate queries and then makes calculations. The results are sent to a report via the Report_Open and Detail_Print events. I am able to create 5 pages but I need at least 7. I use page breaks in the detail section to create the pages. Every page has different information. Any suggestions as to how I can increase the report page length? Or, is there a better way of doing what I want to do?
Click to expand...

The page length is the height of the paper you've specified
for the printer. I believe that what you want is to
increase the detail section height. If so, then here are
the limits on a report's design space:

Each section is limited to ~22 inches
(both Height and Width).

The total of all sections is limited to 200 inches.

You can use the report Header, Detail and Footer sections
for a total of ~66 inches of design space to spread your
controls across (you probably did this already). When
that's still not enough space use Sorting and Grouping (View
menu) to create one or more levels of grouping using a
constant expression such as =1. You can then use the
group's header and footer sections for additional design
space.
 
Back
Top