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?
ouestqueAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.

ET
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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. !!

mx
0
ouestqueAuthor Commented:
Thanks so much!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.