Change a labels property at run time?

[Patrick Hill]

I what to change a labels size and color depending on the
value of a field.
In the reports OnOpen event (and every event) I have

=Reports!Test1.Label6.FontSize=6

but Label6 stays at the design font size of 22.

How do I changing a labels property at run time?

Thanks
Patrick

 

[Fredg]

Patrick,
In the Open event, all you need is:
[Label6].FontSize = 6

If there is some criteria involved to change sizes, then
use the Format event where the label is located:

If [SomeField] = something Then
[Label6].FontSize = 6
Else
[Label6].FontSize = 22
End If

If there is no criteria, why not just change it in design view
and be done with it?

 

[Patrick Hill]

Fred,
The answer is that it must be in an [Event Procedure] to work built with the
"Expression Builder", not built using the "Code Builder"!
Thanks for the lead. (BTY I am going to use a criteria)
Patrick