From: Lloyd on
how do i make my report in Access go to a selected printer
From: Allen Browne on
"Lloyd" <Lloyd(a)discussions.microsoft.com> wrote in message
news:25282CAC-A180-42DB-9000-93A4A42238D9(a)microsoft.com...
> how do i make my report in Access go to a selected printer

Open the report in Print Preview. Then open the Print dialog (Print button
on ribbon in A2007, or Print on the File menu in previous versions.) You can
now choose the printer to send it to.

If you always want it to go to a specific printer rather than the Windows
Default, open the report in design view, open the Print dialog, choose a
printer, and then save the changes.

If you are developing for others, and want them to be able to choose of of
their printers to send the report to (even if you don't have that printer on
your development machine), see the code in this article:
Printer Selection Utility - Users assign printers to reports
at:
http://allenbrowne.com/AppPrintMgt.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.