Report format

[Guest]

I know that there is a problem with reports keeping their formatting in
Access but I have a problem on top of that. I have a report that will not
switch to legal size paper. I have changed it in the page setup area and it
will not change. It stays letter. Does anyone know why or do I have to keep
recreating the report?

 

[fredg]

I know that there is a problem with reports keeping their formatting in
Access but I have a problem on top of that. I have a report that will not
switch to legal size paper. I have changed it in the page setup area and it
will not change. It stays letter. Does anyone know why or do I have to keep
recreating the report?

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.