How can I set a different caption to a report that I send directly to printer

  • Thread starter Thread starter Alphonse Giambrone
  • Start date Start date
One possible solution is to first copy the report and give it a meaningful
name for the spooler. Print this copy and then delete it. Something like...

DoCmd.CopyObject , "Frank", acReport, "OriginalReportName"
DoCmd.OpenReport "Frank", acViewNormal
DoCmd.DeleteObject acReport, "Frank"

HTH
Sam
 
In regard to my previous post...

This will NOT work on MDE files, only MDBs!

HTH
Sam
 
I mean not preview it first, but use

docmd.openreport "rername", acViewNormal

so that I can distinguish the report in the spool window, in order to delete
it if want
 
You must log in or register to reply here.

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

Getting a caption without naming the control 1
Can anyone recommend a good third party plug-in for Zoom closed captioning? 1
Capture Field Caption from a table 2
Command Button Caption on Continuous Form 5
Command BUtton Caption on continuous forms 2
Change form caption 5
Alter Report Captions from a Subform 3
Form to LoadingForm to run Queries for Report? 1

Back
Top