Setting print preview as default in a report

A

AccessNewbie

Not a very challenging question but it's challenging me.
I've created a new Access report and when I run it (it's the last part of a
long macro) it prints the report. I want the report to appear on my screen
(print preview) and not immediately to my printer.
 
A

Allen Browne

How are you opening the report?

If you open it in code such as:
DoCmd.OpenReport "Report1"
change to code to:
DoCmd.OpenReport "Report1", acViewPreview
 
Top