a report bypassing the default printer for another printer

i have one access report that keeps defaulting to my local home printer, even
though i change the default printer to my work printer...

First of all, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Then compact the database:
Tools | Database Utilities | Compact

Next, open the report in design view.
Choose Page Setup from the File menu.
On the middle tab, set the report to Default Printer.
Save.
Compact again.

There is a known bug related to Name AutoCorrect that fouls up the printer
for the report:
http://allenbrowne.com/bug-03.html

If that does not solve the problem, the database needs a decompile or more
major corruption rescue, so post back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"aspgk" wrote in message
news
i have one access report that keeps defaulting to my local home printer,
even
though i change the default printer to my work printer...

Thank you very much.. the page setup adjustment is all i needed and it works
great now.. i have no idea how the specific printer option got toggled...
must be something i did without knowing..

Thanks again for taking the time to respond... have a great weekend.. i owe
you one

Paul Kostelancik

"Allen Browne" wrote:

First of all, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Then compact the database:
Tools | Database Utilities | Compact

Next, open the report in design view.
Choose Page Setup from the File menu.
On the middle tab, set the report to Default Printer.
Save.
Compact again.

There is a known bug related to Name AutoCorrect that fouls up the printer
for the report:
http://allenbrowne.com/bug-03.html

If that does not solve the problem, the database needs a decompile or more
major corruption rescue, so post back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"aspgk" wrote in message
news
i have one access report that keeps defaulting to my local home printer,
even
though i change the default printer to my work printer...