dynamic caption

S

shank

Is it possible to dynamically fill-in the caption on a report?

What I want is "MyReport" & DatePart("yyyy",Now())

thanks
 
D

Dale Fye

Yes,

Private Sub Report_Open(Cancel as Integer)

me.Caption = "MyReport" & Datepart("yyyy", Now())

End Sub
 

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

Adding today's date in the report caption property 4
Runtime Error 3000 - Reserved error -3087 0
Dynamic Report-Caption 5
Invalid use of null on report 1
Link chart to report 4
create PDF filename 1
Trying to get my report to sort correctly 3
changing caption of report 5

Top