• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

Access: Report properties changing on different computers

I am designing Access reports. All of my access reports have all margins = .3 and some are landscape while others portrait. The problem is when I give the Access program to an individual on another computer all the margins change back to one and all reports I set as landscape go back to portrait.

Does anyone know how to fix this problem? is there a way to guarantee that the page properties for my different reports will stay that way?
3 Solutions
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Make sure to set the Default Printer setting for your report. Open the report in Design view, click File - Page Setup, then click the Page tab.

If you still have issues with this, then you may need to setup and select a specific printer for your report. For example, if you're formatting a report on a machine with an odd Default printer (like a label printer, for example), your margins can get screwed up. Try selecting a common printer, like an HP or such, and see if that helps.
Eric ShermanAccountant/DeveloperCommented:
1.) Try using the same printer driver as the machines that will be printing the reports.

2.) In Access 2000 I know this is a know problem especially with reports designed for Legal paper.  I've never found a true solution to be honest.  Anytime I modify legal page reports for clients and they run them the first time they will default back to letter size.  In that case, the very first time they print a legal report that was modified they simply print it to screen and do File/Page Setup, change the paper size to legal, etc. then File/Save.  From that point on the report prints correctly on their machines.

I think in Access 2k there are some page/printer settings that get saved on each machine and that's what causes the problem.

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I would suggest 0.5 for all margins.  That's what I use and it seems to cover all printers.
Report  properties are tied to the printer specified (Default or otherwise).  In fact, if ... there is no Default printer installed - you cannot even create a report, ie open a new report in design view. !!

ouestqueAuthor Commented:
Thanks so much!!!

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now