A Anatoly Kurilin Jul 19, 2006 #1 Hi, what should I put in a condtional text box to make formating work when the field is equal to NULL? Thank in advance, A.Kurilin
Hi, what should I put in a condtional text box to make formating work when the field is equal to NULL? Thank in advance, A.Kurilin
R Rick B Jul 19, 2006 #2 Well, nothing is "equal to null". But is you want to format a field that is null in a certain way, just use IsNull. Set the first dropdown to "Expression Is" In the second field, enter your expression. Something like: IsNull([YourFieldName]) Then tell it how you want null values formatted.
Well, nothing is "equal to null". But is you want to format a field that is null in a certain way, just use IsNull. Set the first dropdown to "Expression Is" In the second field, enter your expression. Something like: IsNull([YourFieldName]) Then tell it how you want null values formatted.