When going into print preview of a report I can display the number of pages in the report page footer. Is there a way to capture this earlier so that it can be placed on a form showing how many pages the report will be on, so the user can make up his mind earlier whether to print a very long report. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Advance aquisition of number of pages 1
- Thread starter ZOR
- Start date
-
1
- #2
In a word... NO.
The only way to determine how long the report is to 'print' it. I assume you know that it can be opened in print preview.
Although it may not be all that much faster or worthwile, you could figure out how many records are behind the report. Just set the control source of a textbox to something like
=Dcount("FieldName", "Table or Query Name")
The Dcount function can also take criteria as the third parameter.
The only way to determine how long the report is to 'print' it. I assume you know that it can be opened in print preview.
Although it may not be all that much faster or worthwile, you could figure out how many records are behind the report. Just set the control source of a textbox to something like
=Dcount("FieldName", "Table or Query Name")
The Dcount function can also take criteria as the third parameter.
- Thread starter
- #3
Thanks Lameid. Problem is the fields in the report shrink and grow which get to get measured somewhere in establishing the number of pages there will be. Have a star for the help, I can see your code being used elsewhere. Have a good weekend.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question