Print No. Of Pages Msg Box

[wizcow]

Hi

When I click on a report print button (on a form), I would like a message box to pop up with the number of pages I am about to print. The message box would ask if I really want to print this many pages. I don't even have an idea where to start.

Thanks
Tom

 

[Rich]

Since accesss has to format the report twice to get a page count I'm not sure it's possible. But you could use DCount on the underlying recordset then divide it by the number of lines the report normally prints per page, should give you a rough idea.
HTH