Adding today's date in the report caption property

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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.
 
That is perfect!!!
THANK YOU!

fredg said:
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.
Click to expand...
 
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?
 
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?
Click to expand...

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