Conditional format expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a notes field if there is nothing in the field I want no color... if
there is any text I want a color. I don't know what to put in the expression
of the Access Conditional Formatting
tried:

"IsNotNull"
"NotNull"

Please help!
Thanks
 
Hi.

I assume this is for a TextBox control (bound to a Memo field called
"Notes") on a form.
In Design mode, make sure you select the control for the Notes field before
you click on Format/Conditional Formatting.
In the first Combo Box in the Conditional Formatting window, select
"Expression Is".
In the TextBox next to it, type: Not (IsNull([Notes]))
Then, make sure you choose the color you want your text box to be if the
Notes field is not Null.

-Michael
 
THANK YOU! That's it! Now can you look at my "scrollbar problem" question? ;)

Michael H said:
Hi.

I assume this is for a TextBox control (bound to a Memo field called
"Notes") on a form.
In Design mode, make sure you select the control for the Notes field before
you click on Format/Conditional Formatting.
In the first Combo Box in the Conditional Formatting window, select
"Expression Is".
In the TextBox next to it, type: Not (IsNull([Notes]))
Then, make sure you choose the color you want your text box to be if the
Notes field is not Null.

-Michael



lmv said:
I have a notes field if there is nothing in the field I want no color... if
there is any text I want a color. I don't know what to put in the expression
of the Access Conditional Formatting
tried:

"IsNotNull"
"NotNull"

Please help!
Thanks
Click to expand...
Click to expand...
 
Back
Top