PirateEyes
New member
- Local time
- Today, 17:34
- Joined
- Jan 9, 2013
- Messages
- 1
This is an old thread but having had the same issue I thought I'd respond.
One accees database I'm currently modifying had a similar issue. The report would be opened in Report View (which is different from Print Preview) so that the report could be interacted with (Drill down reports by double-clicking in areas).
If the user tried to Print Preview (for some reason the users preferred Print Preview over just printing the report) by using a button off the report, Access would lose focus.
This was solved by simply closing out the report, before opening it print preview mode. May not work for this specific use, but thought I'd share in case new users stumbled upon this thread.
Button from the Report View was as follows:
DoCmd.Close acReport, "Report Name"
DoCmd.OpenReport "Report Name", acViewPreview
One accees database I'm currently modifying had a similar issue. The report would be opened in Report View (which is different from Print Preview) so that the report could be interacted with (Drill down reports by double-clicking in areas).
If the user tried to Print Preview (for some reason the users preferred Print Preview over just printing the report) by using a button off the report, Access would lose focus.
This was solved by simply closing out the report, before opening it print preview mode. May not work for this specific use, but thought I'd share in case new users stumbled upon this thread.
Button from the Report View was as follows:
DoCmd.Close acReport, "Report Name"
DoCmd.OpenReport "Report Name", acViewPreview