Access 2007 Changes Report Print Settings

[Guest]

I have a label report built for a single feed Dymo printer. Access 2007 is
changing the printer settings I set in Page Setup to the default printer.
This is causing a huge problem because I have a form with a control that goes
straight to the printer. I have tried all of the fixes that I have found on
Name AutoCorrect. At times I can get it to use the correct printer but it
just seems to default back after a short period. Does anyone have a solid
fix for this? I have seen a lot of post on this bug for Access03 but not
anything for 07.

Thanks,

Greg

 

[Allen Browne]

Yes, this is a problem with A2007. In report design view, the Page Setup
dialog lets you assign a specific printer to the report. Access 2007 loses
this setting, and the report goes to the default printer. The bug is listed
here:
http://allenbrowne.com/Access2007.html#Bugs

AFAIK, MS has not released a fix for this problem yet. You may be able to
set it programmatically. Or, you may be able to use the code from this
utility to workaround the problem until it is fixed:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html