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?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Use a command button to open the report:

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

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.