Report needs to print multiple pages

[David Chambers]

I have a form, i.e. employment application, that is 6 pages, letter size.
When I attempt to create a report to fill in the form, I can only get 2 pages
of information. The report size is limited (I think). How can I create a
report that will print multiple pages of information (either showing all the
fields on the report or just the information for filling in forms that are
multiple pages)?

 

[Allen Browne]

Any section in a report is limited to around 22" high. The solution is to
use multiple sections.

Let's assume your report is bound to a table that has a primary key named
ApplicationID. In report design view, open the Sorting And Grouping box.
Choose ApplicationID, and set Yes for Group Header and Group Footer. Access
adds 2 new sections to the report: ApplicationID Header (above Detail), and
ApplicationID Footer (below Detail.) Since the ApplicationID changes for
every record, all 3 sections (header, detail, and footer) are printed for
every record.

So, now you can place the first couple of pages in the ApplicationID Header,
the next couple in Detail, and the last couple in ApplicationID Footer.

If you need more than 6 pages, repeat this process by choosing the
ApplicationID field again on the next row in the Sorting And Grouping dialog
to get some more sections.