Numbering Pages Differently (Access 2000)

Topic

New Reply

Is there any way to start page numbering back at 1 when the field SchoolName changes? I have a billing printout that prints all the schools, but the client wants the pages numbering by each school instead of the whole report. Is there any way to do this?

Reply | Quote

Replies

Make sure that your report (I assume that it what you’re printing) is grouped by SchoolName, and that you have a group header for SchoolName (it may have zero height). Create an On Format event procedure for the group header section:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
‘ Set page number to 1 when a new group starts.
Page = 1
End Sub

(the name for your group header may be different)

Reply | Quote

What if I have the page numbering as “1 of 3”? How would I do the “of 3” part of the numbering? The first part of the numbering is working great now, by the way.

Reply | Quote

That’s a bit more complicated. See post 496205, the database attached to that post shows how to calculate the number of pages per group.

Reply | Quote

Got it to work. Thanks again, Hans.

Reply | Quote