Dynamically changing report labels

[BrazilTechie]

Hi guys.

How can I dynamically change the title of my report based on the information it contains?

Thanks in advance.

 

[Rick39]

Try this in the On Open Event of the report:

If MyConditionExists then
Me!MyReportLabel.Caption = "Condition1"
Else
Me!MyReportLabel.Caption = "Something Else"
End if

 

[BrazilTechie]

Thanks for the quick reply.