Reports lose Formatting

S

Sara

I have many reports in Access and for some reason,
sometimes when a user tries to run one, it runs properly,
but the preview has lost the formatting. Almost all our
reports are Landscape,yet the report will come up
Portrait, and often lose its margin settings. This
happens in a Macro running a few queries, then a report.
Any ideas?
Thanks
 
F

fredg

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.
 

Ask a Question

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.

Ask a Question

Top