Sending a report directly to a printer

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top