Can't reset report page setup

[Vicki]

I have a report defined in Access that's worked for years. We just
upgraded from Access 2k to Access 2003, and now the report will not
print correctly. The page setup menus show correct default printer,
page size and margins, but the report preview shows only a portion of
the expected page, and outputs many pages instead of the expected one
page. No matter what I try, I can't get the report preview to
correctly render the proper page size. I also get an error message
that the report width exceeds the paper size. The report is 7" wide
and the page size is 8.5x11, with .75 margins all around. I also can't
change the report page parameters to try other paper sizes and
orientations--the settings return to the original parameters.

Nothing changed other than the upgrade to 2003. Any ideas? What am I
overlooking?

 

[Allen Browne]

Hi Vicki

It seems that your database is partially corrupt, and Name AutoCorrect is
the probably cause.

Using Access 2003:
1. Create a new (blank) database: File | New

2. Immediately, uncheck the Name AutoCorrect boxes under Tools | Options |
General.

3. Import everything from the problem database: File | Get External |
Import.

4. Check that your code compiles: press Ctrl+G to open the Immediate window,
and choose Debug | Compile.

Now try opening the report in design view, and check the margins, etc are
correct.

Did you also change your operating system at the same time as you changed
your Office version? If so, the problem could be related to the new printer
drivers.

 

[Vicki]

Thanks for the tips, Allen.

I didn't have the AutoCorrect options selected in either version of
Access, nor did we have an OS change.

Apparently the problem, which I have resolved, was tied to having
assigned the report to the default printer. I fixed this by selecting
a specific printer and changing all the page margins and paper size
settings, which forced the correct rendering of the report. Then I was
able to return the page setup back to the default printer and resave
the report.

Strange thing! I didn't think that choosing the default printer
setting would cause a problem. Thank you very much for your
suggestions, which were helpful.