Get Number of Pages

[Rjc8513]

I am using DoCmd.OpenReport "rpt MY REPORT" to print a report from the OnClick event. The report varies in size and runs anywhere from 100 to over 600 pages.

Is there a way to find out the number of pages that will be printed BEFORE it actually prints? I would like to display the page count in a message box and then let the user decide whether or not to print.

Thanks.

 

[PHV]

Perhaps this will suffice ?
DoCmd.OpenReport "rpt MY REPORT", acViewPreview

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244