How do I force a new report page based on a field's contents?

  • Thread starter Thread starter Shackelbush III
  • Start date Start date
S

Shackelbush III

Using Access 2007
How do I force a new page based on the contents of a field?
I'm doing class reports with multiple classes and multiple students in each
class.
I want to print a seperate page for each class.
I've tried grouping on class number, then sorting on last, then first.
Everything
works fine except that the classes all run together until a page fills up,
then on to the next page..
 
Assuming that you used the report's grouping and sorting dialog, you can
add a group footer based on the class number.

After you have closed the dialog
Click on the new footer and in its properties go to the Format tab.
On the format section, you should see a Force New Page property.
Select After section to generate a page break at the end of each group.

You can even set the visible property of the group footer section to No
(false) and you will get the page break. On the other hand if you want
to you can add controls to give a count of the number of students in the
class in the group footer.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top