I have an access report grouped on employee. I want a new page for each employee. To stop both blank page at end, and empty first page after report header, I use the following vba:
Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As Integer)
'after first name change, set FORCE NEW PAGE to be before change in name - this will stop a blank page being printed at end of report
Me.Section(acGroupLevel1Header).ForceNewPage = 1 'before change in name
This works well, except for the auto numbering page x of y.
I end up with page 40 of 28 on the last page of this report.
How can I fix this?