Change from ReportView to PrintView (1 Viewer)

MyTech

Access VBA
Local time
Yesterday, 21:25
Joined
Jun 10, 2010
Messages
108
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.
 
Last edited:

MyTech

Access VBA
Local time
Yesterday, 21:25
Joined
Jun 10, 2010
Messages
108
Re: Problem changing from acViewReport to acViewPreview

Anybody did the same thing and did not have this problem?
 

Users who are viewing this thread

Top Bottom