Open report using VBA in normal view without printing?

I am new to using reports in Access and I am trying to open the report using VBA without printing.

From searching the web the only way I can find to do this is by using:  docmd.OpenReport "Name", 'acViewPreview'. I don't want to display the report in print preview mode, just the standard report view as if I had clicked on the object manually.
LVL 1
wipnavAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
Use acViewReport instead of acViewPreview
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
These are your options ... see image

mx
Capture1.gif
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"as if I had clicked on the object manually."
That is the same a Print Preview.

Normal ... will directly print the report to printer ...

mx
0
 
wipnavAuthor Commented:
I'm on 2007 and when I double click the report object it opens in a full screen and my ribbon does not change to print/preview mode.

Print preview mode splits the report into multiple pages if the column widths are too great.
0
 
wipnavAuthor Commented:
Thank you. I didn't see that option at the bottom of the list =P
0
All Courses

From novice to tech pro — start learning today.