Access report resize not working

I have a user that tries to print an Access 2013 report but the data doesn't fit on one page. I know that by changing the size it would fit it properly but when clicking on 'size', it doesn't work. This is the only user having this problem. If I try with a different user, when I click on 'size' I can change to whichever I want.


Thank you for your help!
Alan DalaITAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you're having troubles with only one user, then the problem is very likely environmental, meaning there's something wrong with that user's machine.

Printing issues are often caused by faulty/corrupt printer drivers. Try temporarily changing the user's default Windows printer, then run the process again. If that fixes it, you'll need to remove/reinstall those drivers.

Issues like this can also be caused by a faulty/corrupt user profile. On the trouble machine try logging in as a different user. If the problems go away, then you've very likely got a bad profile and you'll have to recreate it.

Also be sure the machine is fully up to date regarding Windows and Office.

Since the database works on other machines I doubt you have corrupt issues, but it's always a good idea to perform standard database maintenance. First make a copy, then do this:

1. Compact the database.
2. Compile the database - from the VBA Editor click Debug - Compile. Fix any errors, and continue doing this until the menuitem is disabled.
3. Compact again.

YOu may also need to decompile the database. To do this, create a standard desktop shortcut with this as the Target:

"full path to msaccess.exe" "full path to the database" /decompile

Run this, then do the 3 steps above again.

You may also want to create a new, blank database and import everything into that new database.
0
 
Alan DalaITAuthor Commented:
I appreciate the the detailed answer. It looks like the printer was at fault, allowing only one size setting(label printer). Changing default printers, fixed the issue.


Thank you.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Glad to help. Don't forget to close out your question!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.