Printing 'Page 1 of N' on page

R

Ryan

Is it possible to print a 'PAGE 1 of N' counter on a
report page.
i.e. does access know the number of pages before it
formats each page ?
 
F

Fredg

Ryan,
If you wish to print the full number of pages on the report, you must make a
control with =[Pages] somewhere in the report.
This forces Access to actually format the report twice, in order to get the
total number of pages in the report.

So add an unbound control to the report, usually in the Page Footer.
Set it's control source to:
="Page " & [Page] " of " & [Pages]

This will show Page 1 of 10, Page 2 of 10, etc., in the footer.
 

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