Conditional format expression

[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

 

[Guest]

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

 

[Guest]

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

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

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