Changing the color of text in a query

  • Thread starter Thread starter nicole62282
  • Start date Start date
N

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
 
nicole62282 said:
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.
Click to expand...


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"
 
Back
Top