G
Guest
Access Report doesn't retain Page Setup settings (Landscape) on a network
printer.
printer.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
This is a known problem, caused by Name AutoCorrect.
Details in the knowledgebase article:
Lost Printer Settings When Name AutoCorrect Is Enabled
at:
http://support.microsoft.com/?id=240826
It really is a good idea to turn this "feature" off. See:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html
Details in the knowledgebase article:
Lost Printer Settings When Name AutoCorrect Is Enabled
at:
http://support.microsoft.com/?id=240826
It really is a good idea to turn this "feature" off. See:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html
G
Guest
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.
the report still goes back to portrait. I am using Access 2000 on a network
printer.
A
Allen Browne
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.
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.