Why does print preview lock up and not allow me to navigate the report pages while in preview?
Posted on 2015-01-22
In Access 2007, I have a report on which I put three buttons, Save (to pdf), Close, and Print. The print is actually mapped to open in print preview. This was because the report contains a lot of information on one page, yet the person needed bigger font. Print Preview has a scroll bar to to magnify the information. My thought is to eliminate the ribbon from the users' view so that they have less options to mess with the database design, otherwise I would direct people to the print preview in the ribbon.
When I open in Print Preview, the view ceases to respond to the mouse and only by clicking on something else, like the task bar, and then coming back to the print preview screen, can I then navigate the print preview pages and other toggles. Is there some setting or coding to overcome this obstacle? The report print preview opens with an embedded macro, but I could switch that to VBA. But if the answer is in VBA, you'd need to walk me through it miniscule step by step.
I do now see at the bottom right of the screen that there is another magnifying glass, which is actually a print preview button, so I might just direct users to that.
But, if I can get the report print preview button to work without locking up the view navigation, I think that would be the best route for our users.