MS Access 2003 - Opening a report without it printing

ms-access vba report ms-access-2003
Justin picture Justin · Jan 14, 2010 · Viewed 20.9k times · Source

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

Answer

hawbsl picture hawbsl · Jan 14, 2010

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.

Related questions

How can I output a report in PDF format, where the name consists of values from fields?

I want to add functionality to my Access 2007 report whereby a PDF copy of the report is created at the click of a button. I know that there is an OutputTo macro which can do this for me, but it …

Read More
Code to loop through all records in MS Access

I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also possible to loop through filtered records and, again, extract data? Thanks!

Read More
Get length of array?

I'm trying to get the length of an array, yet I keep getting this error: Object required Am I doing something wrong? Dim columns As Variant columns = Array( _ "A", "ID", _ "D", "Name") Debug.Print columns.Length ' Error: Object required

Read More