starting page numbering on second page

G

Guest

I have a report that has a page break and I want the page numbering to start
on the page after the break. I'm counting page numbers in groups, and the
page break creates the "title page" for each group. Thanks for any help!
 
G

Guest

Sorry, ignore the first post

Try this
In the Decleration of the report, declare a variable
Dim MyCount As Integer, MyFlag as integer

In the OnOpen Property of the report write
MyFlag = 1
MyCount = 1

In the Onformat event of the section where the page break is in, write the
code
MyFlag = 0

In the OnFormat of the page footer where you display the page number write

If MyFlag = 0 Then
MyFlag = 1
MyCount = 1
Else
MyCount = MyCount + 1
End If
Me.TextBoxName = MyCount

I didn't try it, and I hope you'll get 0 errors
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top