MS Access 2003 - Opening a report without it printing

Question

I used

Docmd.OpenReport "Report1"

from another form and it seems to just want to print the report without actually displaying it. I want to display the report, not print it

score 16 · Accepted Answer · answered Jan 14 '10 at 14:58

16

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.

answered Jan 14 '10 at 14:58

hawbsl

`acViewReport` is the correct one to use for newer version of Access, as it opens the Report in the normal view. see https://learn.microsoft.com/en-us/office/vba/api/access.acview – Aron Einhorn Mar 11 '19 at 17:50
So does that print the report? – johnDanger Nov 19 '19 at 23:41

1 Answers1