Page Setup Changes (Access 2000)

Topic

New Reply

I have created an Access 2000 report and in Page Setup, I changed the default margins and changed the page orientation to landscape. However, the new Page Setup won’t stick, as when the report is opened by someone else or even myself another day, it reverts back to portrait orientation and the default margins. I certainly would appreciate any advice anyone can give me to correct this situation. Many thanks…M.

Reply | Quote

Replies

For the margins, go to Tools, Options, General to check the margin settings.

Reply | Quote

What Gary means by “to check the margin settings” is to turn off the Name AutoCorrect checkbox ‘Track name AutoCorrect info’.
I got this information from Mark’s answer in post 209552
Pat

Reply | Quote

I have found it a good failsafe when specific page settings are required for certain reports – I had a database that needed to print triplicate carbonless receipts on a dot matrix and other reports on the laser printer – that you choose “Page Setup” from the File menu with the report in question opened, click on the Page tab of the dialogue box and select “Use Specific Printer” and specify the printer you want. Those page settings seem to be retained with none of the usual arbitrary nonsense (default settings imposing themselves) that you get otherwise. Particularly useful if you have more than one printer/printer driver set up on your computer or if you are on a network.

Peter

Reply | Quote

This is my favorite Access bug (reports losing customised settings). It keeps getting fixed with service pack releases. Then the new version of Access appears and, guess what, it’s back again. Turning off auto-correct can help. If all reports have the same, customised, margins then set these as the default margins for the reports in the database settings.

Reply | Quote

Many thanks to all–I very much appreciate what you did in answering my call for help so quickly. Our server is down at this time, but as soon as I can get to the database, I will try your suggestions and keep my fingers crossed that they do the trick. Again, many thanks…M.

Reply | Quote