Specific Printer for Access Report

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

I would suggest posting your question in an Access-specific newgroup.


--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


"Randy S" <SalmonDragon@nospam.postalias> wrote in message
news:623E4F62-960A-4ECA-95B9-679AF5119696@microsoft.com...
> 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
>

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".

--
---------------------------------------------------------------
Michael J. Strickland
Quality Services qualityservices2@verizon.net
703-560-7380
---------------------------------------------------------------
"Randy S" <SalmonDragon@nospam.postalias> wrote in message
news:623E4F62-960A-4ECA-95B9-679AF5119696@microsoft.com...
> 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
>