! 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)
 

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

Descenders clipped 0
Printing Outline view - formatting lost 0
Possible to Combine reports to's to a single box? 0
How to have two tables on same line? 1
Detail_Format works in Print Preview but Not When Printing 0
How to automate update on weekly reports spreadsheet 0
Report Header Not Printing 1
Weekly Report 2

Top