Color Text

[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.

 

[Wayne Morgan]

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.

 

[Lou]

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.

.