Print

F

Floyd Forbes

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

Floyd
 
W

Wayne Morgan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Insert Work Print Out - Page 1 Above Meeting Info - Other Pages below 0
Print order of TriFold - Publisher 365 0
Blank Page After Envelope-Label Wizard 5
Publisher adding blank page when printing my booklet... 2
Document won't print 0
Images are pixelated when saving to PDF 0
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0

Top