How can I, in an IIF statement, create the true statement in red?

S

Susan

How can I, in an IIF statement, create the outcome to show in red?

ErrorbyPerson:IIF(table)!(field)=-1,"name"))

I want the "name" to appear in red in the query.

Is it possible?
 
R

Rick B

You can't in a query.

In a form or report, there is a built-in feature (conditional formatting)
that will let you do this.
 
Top