Thank you for the information, however, I turned off the Name AutoCorrect and
the report still goes back to portrait. I am using Access 2000 on a network
printer.
After turning off the Name AutoCorrect:
1. Compact the database:
Tools | Database Utilities | Compact
2. 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"
3. Open the problem report in design view, and make a change (e.g. changing
the name of a label). Save. Close.
4. Compact again.
If you are still stuck at this stage, post back and we'll explain how to
export the report to a text field with SaveAsText, delete it, compact again,
and then get Access to recreate it with LoadFromText.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
