form button Report printing

F

Ferrit04

Hi I have a button on a form that prints a report based on a query i
do NOT show the report it just prints the report when the button is
clicked however i would like a message box to show how many pages are
needed to put in the printer to match the ammount of pages printing
from the Report could anyone help me ASAP be most grateful...
 
M

Marshall Barton

Ferrit04 said:
Hi I have a button on a form that prints a report based on a query i
do NOT show the report it just prints the report when the button is
clicked however i would like a message box to show how many pages are
needed to put in the printer to match the ammount of pages printing
from the Report could anyone help me ASAP be most grateful...
Click to expand...


THe number of pages in a report is calculated by the report
itself. In other words, you need to preview the report to
see how many pages it requires.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Form Button won't print report 2
Can't get report to print 5
recording the print date 3
Code to preview multiple instances of a form 1
Repost:Use runcommand acCmdPrint to print a report 1
Access 2007: Help filtering a report query based on a form field 0
Multiple copies of Report 5

Top