Change label to red based on conditional formatting of another control.

I have a contol text box that changes to red bold when certain conditions are met, but how would I also get the label to changed to red/bold as well?  This is on an ACCESS 2003 report.
Sandra SmithRetiredAsked:
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Make the label a Text box instead, with the Control Source set to:

="Your Caption"

Then use Conditional Formatting on the text box.

Change the label to a textbox (borderless) and apply the same conditions.
Sandra SmithRetiredAuthor Commented:
You both had the same answer so splitting, I would never have thought of that.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.