Print report?

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
Jim,
Do you mean you wish to print the report without previewing it?
DoCmd.OpenReport "ReportName"
or..
DoCmd.OpenReport "ReportName", , ,Where clause here
 
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.
 
Back
Top