Printing Automatically on "OpenReport" event

[Paul H]

Hello all.

I have inherited an Access database that is used for reporting
purposes by a Visual Basic application. The VB app calls Access via
automation, and calls an event in the database that loads data from 2
text files into the database, and runs a report on the data. The
report prints automatically after the OpenReport function has been
called. The strange thing is that I can't find what is telling the
report to print - there is nothing in the Report_Open event except
some code for specifying the ReportSource. If this is commented out, a
print job is still created.

Is there some kind of AutoPrint setting somewhere in the database that
I should know about?

Many thanks - Paul Hutchinson

 

[Andy Hull]

Hi Paul

Typically, the following would be used to "open" a report without printing
it...

DoCmd.OpenReport("ReportName", acViewPreview)

If the 2nd parameter is acViewNormal then the report will print
If the 2nd parameter is missing then the report will print

Regards

Andy Hull

 

[Paul H]

Thanks Andy - you can tell I'm new to Access, can't you!