Dynamic Report Title

[amfroehlich]

I have a report that is run only per year. So I want the year to apper in the title of the report. So how can I make the report title dynamic which will chage with what year the report is run on.

Thanks,

 

[mdmilner]

For a label, you can insert something like this into the reports_open event.

Me.ReportName.LabelName.Caption = Year(Date)

For something like a textbox you can insert this into the ControlSource property of the textbox.

=Year(Date())

Really just depends on what you're using for the title. The first technique works for all the other ways you might try.

Mike