Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Reports _ Report Aligned On My Pc Not Aligned On Others

Posted by: Leah Dec 7 2017, 02:45 PM

First this is an Access 2007 database run in Access 2013. We recently converted to Windows 10 and Office 2013 and this problem happened since with at least one report.

This report has the page header and detail "arranged tabular" however the total boxes in the footer are not arranged and the report header is not arranged.

When we converted I noticed that the report header and the footer did not look aligned and the widths were off so I fixed them and it looked fine. However when a couple of others ran the report the report header and footer were not aligned and the widths were off.

As I have to design reports on my PC, what might cause this as our local IT did not know?

Also my PC is a laptop with a station so I can see on my big screens. Theirs is a PC. Not sure if that should make any difference as the resolution uses the big screens which are the same for all.

Have any clues what might be causing this and what I can do so that mine is like theirs?



Posted by: theDBguy Dec 7 2017, 02:48 PM

Hi Leah,

Typically, screen resolutions affect Forms. For Reports, it is usually the Printer Driver installed on the machine rendering the Report.

Can you confirm all users have the same version of the printer driver you're using on your laptop?

Just a thought...

Posted by: Leah Dec 11 2017, 11:55 AM

Thanks, actually that was the IT's first thought, but as it happened in the actual report prior to printing that did not seem to be the issue. Anyway the IT person did some further research on the web and apparently it had to do with resolution. I was at 100% and the particular users that tried the report were at 125. I went to 125 and rebooted (it was not screwed up until I did) and now my reports are out of alignment in exactly the same way. As some users prefer 100 and other 125 it is rather annoying as I cannot ask everyone to be at one or the other. I am surprised that Access would behave this way, but apparently it does. Shame on them for that in my humble opinion.


Posted by: theDBguy Dec 11 2017, 12:02 PM

Hi Leah,

Glad to hear you found the actual cause of the problem. However, I am not sure I understand exactly what you mean by "screwed up." Are you saying the resolution setting changes the "design" of the report? Or, is it just messing up the layout on screen but prints fine on paper?