Bring up the Print dialog box when printing a report.

  • Thread starter Thread starter Michael Wong
  • Start date Start date
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?
 
Michael,

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

- Steve Schapel, Microsoft Access MVP
 
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...
 
Back
Top