Page Count On Report

  • Thread starter Thread starter Paul M.
  • Start date Start date
P

Paul M.

Hello,
at the bottom of each page (page footer) I have a field (text)
which simply states:
Page n of nn

Just the current page of the total number of pages in the report.

The "nn" part I get using the standard Access [Pages] function but the it
gives an incorrect value, any one got any ideas?

Thanks
Paul Mitchell
 
Paste the following into the control source:

="Page " & [Page] & " of " & [Pages]

HTHs
Dave
 
Dave's suggestion elsewhere in this thread should solve your problem, Paul.
It's worth bearing in mind, though, that if the report includes a large
number of pages, this can be a very significant performance hit. It forces
Access to format the report twice - once to calculate the number of pages, a
second time to go back and fill in the page numbers.

Depending on the circumstances, the information may or may not be important
enough to justify the performance hit.
 
Hi Dave,
sorry I should have been clearer but thats the way its done
at the moment.
Thanks
Paul

Dave Brydon said:
Paste the following into the control source:

="Page " & [Page] & " of " & [Pages]

HTHs
Dave

Paul M. said:
Hello,
at the bottom of each page (page footer) I have a field (text)
which simply states:
Page n of nn

Just the current page of the total number of pages in the report.

The "nn" part I get using the standard Access [Pages] function but the it
gives an incorrect value, any one got any ideas?

Thanks
Paul Mitchell
Click to expand...
Click to expand...
 
Back
Top