Color Text

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

Hello All,
Can someone please help me this is simple task? I would
like to add a textbox on a form that displays OPEN when
the [resolved] has not been entered and to display closed
when the [resolved] date is entered. I would like to
have the text RED for Closed.
Thank you.
 
Set the Control Source of the textbox to

=IIf(IsDate([Resolved]), "Closed", "Open")

Next, right click the textbox and choose Conditional Formatting. Set it to
Field Value, Equal To, "Closed" and choose Red in the font color drop down.
 
Wayne,
Thank you, it works great..
Lou
-----Original Message-----
Set the Control Source of the textbox to

=IIf(IsDate([Resolved]), "Closed", "Open")

Next, right click the textbox and choose Conditional Formatting. Set it to
Field Value, Equal To, "Closed" and choose Red in the font color drop down.

--
Wayne Morgan
MS Access MVP


Hello All,
Can someone please help me this is simple task? I would
like to add a textbox on a form that displays OPEN when
the [resolved] has not been entered and to display closed
when the [resolved] date is entered. I would like to
have the text RED for Closed.
Thank you.
Click to expand...


.
Click to expand...
 
Back
Top