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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change text box background color depending on value in Label Reports 1
visible label based on text value 1
Marginless Labels 2
Excel Changing chart label colors based on a value in a cell 0
Excel conditional formatting with Weeknum 4
Conditional formatting on a label 2
How to Export Gmail Emails to PST Format? 4
hide labels in report for zero fields 2

Back
Top