Changing report label in VBA - can this be done? 1

[davidfc]

Whats the syntax for changing Caption property of a Report label after the report is open?

I have tried:
DoCmd.OpenReport "ReportName", acPreview
Reports!ReportName.Label28.Caption = "To:" & David"
but the report shows just the original default value of "To:"

I'd be grateful for any suggestions.....

 

[RoyVidar]

Try using the on open event of the report, or the on format event of the section where the label resides.

Roy-Vidar