Page numbering in report

[scra]

I would like to add a page number on the report, but how do I add it on page footer if the page number starts at Page 8 and goes through 10.

 

[jiqjaq]

If you want to set the starting page number, you can use:
Me.Page = 8 (to set to 8) or = to your desired number. This resets the current page number value. You would put this statement in the Report_Open procedure of the VBA code.

 

[scra]

OK. I placed the code on OnOpen procedure, but where is it showing on the report??

 

[jiqjaq]

You need to add a textbox field to the Report, in design view. On the Insert menu, click "PageNumbers".

 

[scra]

I have 2 pages. Would like to start at page 6 and end at page 7. I tried Me.Page = 6, but it repeated on second page.

 

[PaulBricker]

You can take a look at this thread.
thread703-462688

 

[scra]

Thanks, Paul! It works!