How can I change the starting page number of a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a document that is printed in multiple reports. In the 2nd report, I
want the first page number to be 5.
 
Shirlo said:
I have a document that is printed in multiple reports. In the 2nd report, I
want the first page number to be 5.
Click to expand...


Use the page header (or footer if you don't have a page
header section) section's Format event to reset the page
number:

If Me.Page = 1 Then Me.Page = 5
 
I guess I need more info. I tried putting your statement in the ON FORMAT
line of the EVENT tab in the page header properties, and it says it can't
find a macro ME.
 
Shirlo said:
I guess I need more info. I tried putting your statement in the ON
FORMAT line of the EVENT tab in the page header properties, and it
says it can't find a macro ME.
Click to expand...

In that box drop down the list of choices and choose [Event Procedure].
Then press the build button [...] to the right of the box. That will take
you to the VBA editor window and that is where you put your code. Access
will automatically create the lines that define the start and end of the
code block. Your line(s) need to go between them.
 
Rick answered the question, but I want to add that you
should not confuse the event **properties** and the event
**procedures**. The event properties are used to indicate
how an event is connected to the corresponding event handler
macro, VBA function or event procedure.
 
Back
Top