Numbering Pages Differently (Access 2000)

[JenniferS]

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?

[HansV]

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)

[JenniferS]

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.

[HansV]

That's a bit more complicated. See <post#=496205>post 496205</post#>, the database attached to that post shows how to calculate the number of pages per group.

[JenniferS]

Got it to work. Thanks again, Hans.