Problem changing from acViewReport to acViewPreview
Hi there,
I open my report with a filter with following code:
DoCmd.OpenReport "MyReport", acViewReport, , MyFilter
On the report I have a button to open the same report in Print Preview view, with following code:
DoCmd.OpenReport "MyReport", acViewPreview
So the report opened now in Preview mode, and still filtered with the previous filter, which I want.
The problem is, that after it opens in Preview mode, MS Access does not normally focus on the report. I can only scroll the report up and down and nothing more.
But as soon as I focus my computer on something outside MS Access, when I focus back to Access, everything is fine.
Thanks for help.
Hi there,
I open my report with a filter with following code:
DoCmd.OpenReport "MyReport", acViewReport, , MyFilter
On the report I have a button to open the same report in Print Preview view, with following code:
DoCmd.OpenReport "MyReport", acViewPreview
So the report opened now in Preview mode, and still filtered with the previous filter, which I want.
The problem is, that after it opens in Preview mode, MS Access does not normally focus on the report. I can only scroll the report up and down and nothing more.
But as soon as I focus my computer on something outside MS Access, when I focus back to Access, everything is fine.
Thanks for help.
Last edited: