How can I change my default printer to another printer via VBA?

[hanski]

Hi.

I would like to print my form to printer, but not allways to my defaul
printer.

I would like to select which printer to print from time to time.

Is it possible to select the printer via VBA?

Thanks!

 

[Allen Browne]

What version of Access?

In Access 2002 or later you can set the Printer object to the member of the
Printers collection you want to use

There's a free example database that uses that approach here:
http://allenbrowne.com/AppPrintMgt.html

To return to the Windows default printer again, use:
Set Printer = Nothing