Change font color in a SWITCH statement

Hello, how can I change the font color from black to RED for the word "Past Due" below?  see the bold part.  The below is in a query design builder window:

PastDueOrPendingSWITCH: Switch([Due Date Per Docs]<Date() And [Completed] Is Null,"Past Due",[Due Date Per Docs]>=Date() And [Completed] Is Null,"Pending",[Completed] Is Not Null,"Completed",True,"")
pdvsaProject financeAsked:
Who is Participating?
You can use conditional formatting. Highlight the text box, go to the Design tab and select Conditional. In Condition 1 make these selections in the 3 boxes:  "Field Value is", "Equal to" and "Past Due" (With quotes).

pdvsaProject financeAuthor Commented:
ahhh...too easy.  I dint think of that.  thank you
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.