Access report changes from lanscape to portrait.

[steph]

My reports keep losing their formatting - they change to portrait with
margins, despite being set as landscape with none. They also revert to single
column. Can I write a macro to format them on opening?

 

[fredg]

My reports keep losing their formatting - they change to portrait with
margins, despite being set as landscape with none. They also revert to single
column. Can I write a macro to format them on opening?

If you are using Access 2000 this is a known bug and is documented in
the Microsoft Knowledgebase article:
Q245021 'List of Fixed Problems in Microsoft Office 2000 Service
Release 1/1a (SR-1/SR-1a)'
And specifically:
Q240826 'Lost Printer Settings when Name Autocorrect is turned on'

Turn off the Name AutoCorrect feature as a temporary 'fix'.
Then download and install the Service Release 1/1a.

Even if you are not using Access 2000, turn off the Name AutoCorrect.
Tools + Options + General Tab.