Adding today's date in the report caption property

[Guest]

I have several reports that I "print" as a pdf and email to coworkers. When
I print a report it is automatically saved as the caption property txt. What
I would like to do is set my caption property to "Report 1 MM/DD/YYYY"

Is this possible?

 

[fredg]

I have several reports that I "print" as a pdf and email to coworkers. When
I print a report it is automatically saved as the caption property txt. What
I would like to do is set my caption property to "Report 1 MM/DD/YYYY"

Is this possible?

You can set a Access report's caption property when it is run by
coding the Report's Open Event:

Me.Caption = "Report 1 " & Format(Date,"mm/dd/yyyy")

How this will carry over to any .pdf document I have no idea.

 

[Guest]

That is perfect!!!
THANK YOU!

You can set a Access report's caption property when it is run by
coding the Report's Open Event:

Me.Caption = "Report 1 " & Format(Date,"mm/dd/yyyy")

How this will carry over to any .pdf document I have no idea.

 

[Pluggin Away]

This was an a solution to a problem I was having and it works great until I
try to get a macro to print the report then the "me.caption" is overwriten.
Got any ideas?

 

[fredg]

This was an a solution to a problem I was having and it works great until I
try to get a macro to print the report then the "me.caption" is overwriten.
Got any ideas?

No ideas unless you tell us what the macro actually does.
And is it really a Macro or is it Code ([Event Procedure]) ?