Conditional Formatting

[Antonio]

I am using the Conditional Formatting tool to make
certain data fields change their back color when the data
field contains a specific word "Admitted".
I am using the following expressions in the following way
to the back color of the text box called "PatnName".

[SenderID] = "Admitted" to change the back color to
orange.

IsNull([DateRcvd])to change the back color to red.

Here is my problem. I want the back color to change to
white(the normal back color) when the [DateRcvd] data
field is no longer empty (null) But I cant seem to make
it work. I tried:

IsNotNull([DateRecvd])

Do I have the syntax right?

 

[tina]

try

[DateRcvd] Is Not Null

or

Not IsNull([DateRcvd])

hth

 

[Antonio]

Tina, thanks for the help. Worked like a charm

-----Original Message-----
try

[DateRcvd] Is Not Null

or

Not IsNull([DateRcvd])

hth

I am using the Conditional Formatting tool to make
certain data fields change their back color when the data
field contains a specific word "Admitted".
I am using the following expressions in the following way
to the back color of the text box called "PatnName".

[SenderID] = "Admitted" to change the back color to
orange.

IsNull([DateRcvd])to change the back color to red.

Here is my problem. I want the back color to change to
white(the normal back color) when the [DateRcvd] data
field is no longer empty (null) But I cant seem to make
it work. I tried:

IsNotNull([DateRecvd])

Do I have the syntax right?

.