Paper size in print setup won't change

[Guest]

I cannot change from letter to legal size to print one particular report.
When I click legal in print setup it doesn't change from letter. Other
reports I have in this computer are no problem-I can change from legal to
letter and back. This report was printing to legal-I don't know what changed
it. Thanks for any help.

 

[Allen Browne]

This may be another Name AutoCorrect issue. See:
Lost Printer Settings When Name AutoCorrect Is Enabled
at:
http://support.microsoft.com/?id=240826

If so, this should fix it:
1. Uncheck the Name AutoCorrect boxes under:
Tools | Options |General

2. Compact the database:
Tools | Database Utilities | Compact

3. If the report has a module, decompile a copy of the database by entering
something like this at the command prompt while Access is not running. It is
all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Compact again.

5. Select the report in the Database window, copy (ctrl+C) and paste
(Ctrl+V). Once you have established that the copy works you should be able
to delete the original report, compact agian, and then rename the copy back
to the original name.