If It Can Be Done - Change a Report Title in VBA?

[justagrunt]

Greetings.
How does one change a report title in VBA.
Two forms, same information.
One is a Proforma Invoice, the other a Commercial Invoice.
Without creating another report template can I change a label or unbound text box, text, to read either Proforma or Commercial, in VBA when prompted prior to printing.
Thanks
Kind Regards
Bill

 

[scriverb]

In the OnOpen event procedure you can change the .caption property of a label.

Me![Report_Title].Caption = [red]vReportName[/red] & " Invoice"

Create a database level Global variable called vReportName

Global vReportName as string

Now in the form where you call up the printing of the report just store either "Performa" or "Commercial" in the variable vReportName. Then call the report.

vReportName = "Performa"
DoCmd.OpenReport "rptYourReportName"

This should do it for you. Good luck.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[justagrunt]

Cheers Bob
Kind Regards
Bill