change printer settings for access report using vba

[Doug]

I need to be able to change the printer for a report on the fly as we have
different letterheads depending on the data. Can this be done in VBA?

 

[Allen Browne]

Changing the printer settings on the fly is a somwhat arduous task in
Access.

Here's a starting point:
http://msdn.microsoft.com/archive/d...umControllingYourPrinterinMicrosoftAccess.asp

 

[Doug]

Thanks for the advice. It was as I feared!!