Sending a report directly to a printer

[Guest]

How do I send a report (via a button) directly to a printer bypassing the
print preview screen?

I still want the general office printer selection dialog box to open up, so
the users can select their local printer.

Cheers,
GLT.

 

[Allen Browne]

If you are using Access 2002 or later, you can set the Printer object before
you OpenReport in acViewNormal.

You probably want to create a little unbound form with a list box that you
populate with the members of the Printers collection.

You can even use a custom property on the report so that it remembers to use
that printer again next time the report is opened. Downloadable example in:
Printer Selection Utility - Users assign printers to reports
at:
http://allenbrowne.com/AppPrintMgt.html

The article also contains some links for solutions in earlier versions.