Programmatically Changing the Caption of a Report Label 1

[hsp7777]

Greetings,

I was wondering if it is possible to programmatically change the caption of a label on an Access report? For instance, I am attempting to use the following code to change the caption of a label (on a report). I receive no error message during execution, but the caption of the label never changes. Is this even possible?

Code:
strCaption = "Tasks due for the date of : " & Now()
Reports("rptPrintTasks").Controls("lblTasksDue").Caption = strCaption

Thanks in advance!

hsp7777

 

[FancyPrairie]

Where are you sticking that code? Try it via the OnOpen statement of the report.

 

[hsp7777]

I was placing the code behind a command button on a form. Placing the code in the "On_Open" statement of the Report worked.

Thanks again!

hsp7777