Paper size in print setup won't change

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top