Print report?

J

Jim

Is there a way to print out a report without showing the
print preview in a command button on a form
Thanks in advance,

Jim
 
F

Fredg

Jim,
Do you mean you wish to print the report without previewing it?
DoCmd.OpenReport "ReportName"
or..
DoCmd.OpenReport "ReportName", , ,Where clause here
 
F

Fredg

Jim,
I do believe you are mistaken.
The default argument for OpenReport is acViewNormal.
Only acView Preview or acViewDesign need to be set, otherwise it prints.
DoCmd.OpenReport "ReportName"
sends the report directly to the printer.

To print just the data of a form:
File + Page Setup + Margins
Check the 'Print Data Only' box.
 
Top