How can I switch a report from report view to preview and make sure the report filters are read so that not the full report is opened?
Posted on 2015-01-28
I'm trying to make it so a person can reopen a report in print preview so that they can easily zoom in and out on the report, to make it easier to see. Setting a button to open in print preview locks up navigation so that I can't navigate at all in print preview.
Setting the button code to
DoCmd.Close acReport, "YourReportNameHere"
DoCmd.OpenReport "YourReportNameHere", acViewPreview
reopens the report in print preview without locking up, but it doesn't read the report conditions that were used to open the report, so the full report opens - unfiltered.
I'm disabling the ribbon and menus, so those are not options.
This report opens from a form. On the form are 4 combo boxes. The macro builder behind the button has the conditions set to look through the 16 different scenarios of combo boxes being null or not null and then opens the report in report view based on which condition matches.
A manager wants to be able to zoom in to see the report better. That is the end goal.
How can I open the report in print preview that will acknowledge the selected condition and allow for navigation in the preview mode?
Or, if you have another user friendly method of zooming in, while preserving the selected report condition, that would be helpful.