Changing colors in IIf statement expressions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write an IIf statement in a report where the result for a TRUE
statement returns the field in one text color and the result for a FALSE is
another? For example, in the following statement, I want the true statements
to return the text statement "Open" in blue, and the others in black:
IIf([DateCompleted] Is Null, "Open", [DateCompleted]). How can this be done.
 
Tried that, but I couldn't figure out how to make it work with a null value
and/or a text field. Also, what part of th IIf statement will the
CONDITIONAL FORMATING be based on?
--
-BP-


Rick B said:
Why not just use the built-in CONDITIONAL FORMATTING to set the color?


--
Rick B



Bendleton said:
I am trying to write an IIf statement in a report where the result for a TRUE
statement returns the field in one text color and the result for a FALSE is
another? For example, in the following statement, I want the true statements
to return the text statement "Open" in blue, and the others in black:
IIf([DateCompleted] Is Null, "Open", [DateCompleted]). How can this be done.
Click to expand...
Click to expand...
 
Back
Top