| | |
|
|
|
Conditional Formatting |
|---|
| message from Antonio on 26 May 2004 |
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 replied to Antonio on 27 May 2004 |
try
[DateRcvd] Is Not Null
or
Not IsNull([DateRcvd])
hth
"Antonio" <brunoponce@hotmail.com> wrote in message
news:1318001c443a8$7ea62180$a601280a@phx.gbl...
|
| Antonio replied to tina on 27 May 2004 |
Tina, thanks for the help. Worked like a charm:)
data
way
|
|
Archived message: Conditional Formatting (MS Access)
