Changing Label Caption in a Report at runtime

[diablo007]

Hi, Im having a bit of trouble changing the label on a report dynamically at runtime. The report is suppose to show sales figures for advisers and at the top in a label box it should show the date those sales figures relate to. The user is able to select the start date and end date and the report runs fine. Except when i try to update the label box caption (when the report is opened) to the start and end date, the caption property for the label dosnt appear. In fact when i type the label name and then "." no options appear at all. I have to reference it using me.label
but then there is no caption option there either....
Im using Access 2000.
Any help would be much appreciated.
Thanks

 

[BlackKnight]

Hi,

If I understand you correctly you want to change a label's caption in a report to the start/end dates. Add the following code to the ON FORMAT event of the section your label is located:

Me!Label1.caption = "StartDate - EndDate"

Have a good one!
BK