Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PAGE NUMBERS NOT BREAKING CORRECTLY

Status
Not open for further replies.

SeanB

Programmer
Jul 19, 2001
70
0
0
US
I have a report where I added Page Numbers to it. I have a header called Invoice Header which is where the Page number text box is. THe Page numbers keep running and they don't start over on each new Invoice. For example if Invoice #1 had 2 pages and Invoice #2 had two pages it goes stright through Page1-4 and not Page1-2, Page1-2.
Any idea?
 
There are step by step instructions in the help file. Search on "Reset page numbers"

Basically you need to move the page number to the *page header* section. Then code the *group footer's* on format event

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
[page] = 0
End Sub

Also be sure to set the *group header's* Force New Page property to "before section"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top