Conditional Formatting of Labels

  • Thread starter Thread starter Cameron
  • Start date Start date
C

Cameron

I was wondering if it is possible to change the
formatting of label based on the value in a particular
control.

Thanks,
Cameron
 
You can use code in the On Format event of the section containing the label
like:
If Me.MyControl > 1000 Then
Me.lblMyLabel.ForeColor = vbRed
Else
Me.lblMyLabel.ForeColor = vbBlack
End If
 
Back
Top