S shank Dec 23, 2008 #1 Is it possible to dynamically fill-in the caption on a report? What I want is "MyReport" & DatePart("yyyy",Now()) thanks
Is it possible to dynamically fill-in the caption on a report? What I want is "MyReport" & DatePart("yyyy",Now()) thanks
D Dale Fye Dec 23, 2008 #2 Yes, Private Sub Report_Open(Cancel as Integer) me.Caption = "MyReport" & Datepart("yyyy", Now()) End Sub
Yes, Private Sub Report_Open(Cancel as Integer) me.Caption = "MyReport" & Datepart("yyyy", Now()) End Sub