Select a Printer different Than Default Printer

[DMHCCI]

Is there a way to select a printer with coding, or macros that is different than the default printer in Windows when printing access reports. I want to print labels on a special label printer that is not the default printer.

 

[Remou]

Yes, 'how?' depends on your version of Access.

 

[DMHCCI]

Access 2000 running under Windows XP

 

[Remou]

There is this:

http://support.microsoft.com/kb/129397

It is easier with later versions of Access.

 

[DMHCCI]

What would be the method for 2003Office?

 

[Remou]

This way:

http://support.microsoft.com/kb/284286

It is also possible to bring up the printers dialog box in 2000 so the user can change the printer.