Specific Printer for Access Report

R

Randy S

Hi
We use several Access databases that we wrote in house. They have worked
fine for years. I upgraded couple of our machines with Office 07 to test
with. Using the 07 boxes I was trying to change the printer settings from
default printer to a specific printer. I open the page setup window. Change
it, it appears to change, I click ok. Then if I open the page setup window
immediately again It is back to default. I have trying on several forms and
different database and different machines. The only why I can get them to
change and retain the setting is to go back to the older version of access.
At the point the 07 boxes print to the correct printer. I just cannot change
the setting use Access 07. I was wondering if anyone has any ideas about this.

Thanks
Randy
 
M

Michael J. Strickland

This is a bug/feature of Access 2007. A workaround is to change the
report printer using the Print->Preview function
(Rt Click on report, select "Preview", click "Page Setup" button)
These page setup changes will "take".
 
Top