If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formating Question
Hi, what should I put in a text box "equal to" if I want a condition work
when the control value is equal to NULL? Thanks in advance, AK |
#2
|
|||
|
|||
Conditional Formating Question
isnull(ControlName)
"Anatoly Kurilin" wrote in message ... Hi, what should I put in a text box "equal to" if I want a condition work when the control value is equal to NULL? Thanks in advance, AK |
#3
|
|||
|
|||
Conditional Formating Question
Use the Expression option and the expression is isnull(controlname)
If you use the field name and value I think Is Null will also work "Chegu Tom" wrote in message ... isnull(ControlName) "Anatoly Kurilin" wrote in message ... Hi, what should I put in a text box "equal to" if I want a condition work when the control value is equal to NULL? Thanks in advance, AK |
#4
|
|||
|
|||
Conditional Formating Question
Yes, it works, thanks!
"Chegu Tom" wrote in message ... Use the Expression option and the expression is isnull(controlname) If you use the field name and value I think Is Null will also work "Chegu Tom" wrote in message ... isnull(ControlName) "Anatoly Kurilin" wrote in message ... Hi, what should I put in a text box "equal to" if I want a condition work when the control value is equal to NULL? Thanks in advance, AK |
Thread Tools | |
Display Modes | |
|
|