How to force report to open in Print Preview mode

I have built a report that uses the OnFormat event of the Detail section to capture and calculate values for later use in the report. However, this event only fires when the report is being viewed in Print Preview mode. Is there an event that will fire whenever the detail level of the report is filled in, regardless of the view? If not, how do I force the user to always be in print preview mode? The Switchboard seems to want to always open in Report View mode.
RichAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
Use a command button to open the report:

Private Sub Command1_Click()
DoCmd.OpenReport "Report1",acViewPreview
End Sub

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
If necessary, change the Switchboard command to Run Macro, then have the Macro open the report in Preview mode.

mx
0
 
RichAuthor Commented:
Thanks. That is what I need to do.
0
All Courses

From novice to tech pro — start learning today.