Printing issues after upgrade

[Guest]

I have a client with an inherited access database and I'm not real good at
access, but I have to fix it....ugh.

Ever since the upgrade to 2003, a report that is printed prints a tiny
version and sometimes it's landscape and sometimes portrait. Any ideas on
what might be doing this and how to fix it?

Thanks,
Carla

 

[Allen Browne]

Firstly, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact

Next, open the report in design view.
Choose Page Setup in the File menu.
Make sure the report is set for Default Printer, or the correct one.
Make a design change on the report (e.g. change the name of a label.)
Save the change.

If that does not fix the problem, it could be a faulty printer driver. I
have seen an issue similar to what you describe with an HP LaserJet, and
replacing the printer driver fixed the problem. (Access uses the driver
metrics to calculate the layout of the report.)