Not sure where you would want this information, but you could use :
="Page " & [Page] & " of " & [Pages]
in a report footer and have the report set to preview first, then print.
The PAGES property (read only) contains the total number of pages in a report. So if you really wanted the user to know ahead of time how much paper to use, you can just pop up a message box:
Sub Report_Activate
msgbox "This report is " & me!Pages & " pages long. Please put enough paper in the printer." , vbOkonly
end sub
78.5% of all statistics are made up on the spot.
Another free Access forum:
Hmm. We may need to find a "later" event. Try the PRINT event.
It's possible Access doesn't know how many pages there are until the first page starts printing..?? 78.5% of all statistics are made up on the spot.
Another free Access forum:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.