! How To Print Report !

W

Wembly

Hi,

I want to generate and print a report directly to the
printer rather than getting it to preview.

Rather than using acPreview for a report, is there a way
to generate the report and send it directly to the printer
so that the user does not see the report on the screen?

Thanks.
 
A

Al Campagna

Wembly,
Just leave out the acPreview portion of the OpenReport command.
DoCmd.OpenReport "frmYourFormName", acViewPreview (allows preview)
DoCmd.OpenReport "frmYourFormName" (prints immediately to the
"default" printer)
 
Top