Bring up the Print dialog box when printing a report.

M

Michael Wong

There is this command in Vba:

DoCmd.OpenReport View:=acViewNormal

But this will immediately print the report.

How can I bring up a dialog box to allow user to change printing settings
before printing?
 
S

Steve Schapel

Michael,

Try this...
DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdPrint

- Steve Schapel, Microsoft Access MVP
 
M

Michael Wong

Thanks a lot, just need to add one more line...

Steve Schapel said:
Michael,

Try this...
DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdPrint

- Steve Schapel, Microsoft Access MVP
Click to expand...
 

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

printing multiple reports with one print dialog box 0
How to print a report with multiple tab controls 1
How to Define the Print Job Name in Print Queue for a Access Report? 3
Printing two reports at once. 0
Set report criteria in code? 2
Closing print preview after printing 4
Gantt task bars not printing 2
Upgraded from Win 7 to Win 10. Publisher printing black. 1

Top