MS Access 2003 - Opening a report without it printing

ms-access vba report ms-access-2003

Set the acView argument to acViewPreview:

docmd.OpenReport "Report1", acViewPreview

Access Help says you can use one of these AcView constants:

acViewDesign acViewNormal acViewPreview

acViewNormal is the default and prints the report immediately.

CodeHunter