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

Code to cut a paragraph that's followed by a table 2
Change Style to 'Keep with previous' instead of Keep with Next 1
Treating multiple paragraphs as one 2
Calculation Based on Dynamic Variables (What-if Scenario) 0
Using Office Forms and dynamically updating the excel backend 0
create PDF filename 1
Word Template Issue 2
Link chart to report 4

Top