Controlling which printer a report goes to

[Phil Smith]

Without user intervention, and regardless of which printer is set up as
default, how can I force a particular report to go to a particular printer?

I am not trying to make it impossible to print this somewhere else, but
it will almost always be run from a marco executed from the command line
with no other user intervention.

 

[Douglas J. Steele]

See whether Albert Kallal's Printer change code at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html helps.

 

[Clifford Bass]

Hi Phil,

In the Page Setup, on the Page tab, you can tell it to Use Specific
Printer. If someone wants to print elsewhere, they can use the File, Print
method and then redirect it to another printer.

Clifford Bass