Changing the color of text in a query

[nicole62282]

I have done this before and forgot how to do this. In my query, when the
field says yes, I want it to display in red text. What is the formula to do
this? I know it is very simple, but my brain is botched today.

TIA,
Nicole

 

[Marshall Barton]

I have done this before and forgot how to do this. In my query, when the
field says yes, I want it to display in red text. What is the formula to do
this? I know it is very simple, but my brain is botched today.

You should not be displaying a query's datasheet for users
to see. Instead, you should create a form and use the query
as the form's record source. This way you can lock control
ans use validatation code to prevent users from messing with
data they should not be changing.

Either way, you can set a query field's (or a dorm
control's) Format property to specify on of the basic
colors. For example, a YesNo value can use:

"";[Red]"Yes";[Green]"No";[Yellow]"Unknown"