Graphical issue with resizing pop up reports

jonnygill

New member
Local time
Today, 21:12
Joined
Feb 26, 2014
Messages
3
I am creating a system for my work in Access. Almost completely done and I have made some reports (based on queries) for one of our managers to view. I have these loading from a command button on a form with the code:

DoCmd.OpenReport "-reportname-", acViewReport

I have the pop up parameter set to yes as I am locking down the program for users so that they don't have access to any menus etc, so when I was loading the reports there was no way for them to get back out of them again.

When they load they work fine and display fine. The issue comes if I try to maximise, minimize or otherwise change the size of them. I have a screenshot of the original state of the report and then when it is maximised (although unfortunately my account is not verified so I cannot add them) but basically the window graphic bugs out. Scrolling with the mouse wheel seems to refresh the page and fix the issue, but only temporarily. Scrolling using the scrollbars leaves a trail of scrollbar selectors behind it. I have tried different screen resolutions and display settings etc. I am running Access 2010 on Windows 7 Professional SP1 64-bit with 8GB of ram so I don't feel like it should be a display issue but that is all I can think.

Any ideas?

(Please note, I have also posted this question on the MSDN forum but haven't received a response. Not meaning to cross post.)
 
I have had similar issues which is why if I make a report pop-up, I set the border to dialog so that they cannot be resized.
 
Thanks for the response, EM. That's a good idea. It is only because one of my reports has a chance to be quite lengthy so I was hoping to be able to full screen. Maybe I will have to go with that. I would still like to know what it is though, just for my peace of mind.

I tried the same thing on an XP user's PC and it worked fine! (Note, the XP computer is being upgraded soon, fear not for my security!)
 
Not surprised, XP was so much better. I still have one at home but they insisted on upgrading me to Windows 7 a few months ago.

I don't know what causes it but it is annoying. I usually don't set my reports to pop-up for this reason. You can still disable the menu by using:

Code:
DoCmd.ShowToolbar "Ribbon", acToolbarNo

on load. You can change it back to yes to enable it again.
 
And you can make it modal even if it is not a pop-up. That is what I do.
 
Agreed re: XP. And thanks, I think I will probably just stick with having dialog edges and removing the minimise and maximise buttons from the report window, unless anyone comes back with a magical fix.
 

Users who are viewing this thread

Back
Top Bottom