Exceeding The 22" Page Length

  • Thread starter Thread starter Outpost
  • Start date Start date
O

Outpost

I have a 4 page form I am attempting to populate based on a query. I
am hoping for a workaround for the max page limit. I inserted the form
as an embedded picture. I am using A2k3. TIA
 
You cannot circumvent the page length, but it is per section.
You can work around the limit by adding sections to the report.

1. Open the report in design view.

2. Open the Sorting'n'Grouping dialog (View menu).

3. Choose the primary key field, and in the lower pane answer Yes for Header
and Footer. This gives you 2 new sections.

4. Repeat step 3 if you need more sections. Yes, you can have multiple group
header/footer sections based on the same field.
 
Allen;
Thanks for the solution. I also considered dumping it in a Merge to
Publisher. I will run some time trials to determine which direction I
need to go. I am curious as to the method used most frequently by
developers; Access or Merging the data to another app. I guess there
are too many variables involved to provide a one answer fits all.
Thanks again.
 
Back
Top