Discussion Locked

Force Landscape Printing in Access 2000

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I keep changing the page settings to landscape and saving and they are not being retained with the report. Guessing upon exit/reboot it is somehow being overridden by the default printer settings.

Would like to add vba code to the report that forces the report to change to landscape on open.

Guess I'm tired, been working on it for a while and it's not working.

6 replies

by homer simpson instructor at large

Have you taken off Name Autocorrect? This is a known issue that may cause a report to reset to the default settings. Go to Tools->Options->General tab and disable Name Autocorrect. Also when you design the report/form etc. use a specific printer and save the changes. You can check this out through page setup-> Page tab while in the design view of your report. Choose a specific printer and save the changes. If you are using the setting of default printer and you use different printers, thismay cause the margin settings and orientation to change back to default.

by public

The AutoName was on - But selecting a specific printer is going to be very time consuming. This report is going on the Front End mdb on several computers each with a different type of default printer. Which would mean opening it on every computer.

by mbarker734

Question: Are you setting the print to landscape in the Print... function. If so, try doing it in Page Setup...

That should solve you problem.

Mark

This discussion is closed to new replies.