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
 
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
 
Back
Top