Print

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

Is there anyway to setup a report to just print the first
page only, without using File and print.

Floyd
 
Check the DoCmd's PrintOut method to see if it helps you. It will print the active object,
so if you had a button open a report in preview mode, run the printout command, then close
the report, that should do the trick.

I just tried the following in a button's click event and it worked.

DoCmd.OpenReport "Report1", acViewPreview
DoCmd.PrintOut acPages, 1, 1
DoCmd.Close acReport, "Report1", acSaveNo
 
Back
Top