Conditional Formatting

[Kembo]

I'm trying to make a text box on a form highlight if the
user does not enter data. I tried to use conditional
formatting, but do not know what to enter as my
expression for "blank field" Any Thoughts?

 

[Tony C]

Code for any null field is "Is Null".
However "Conditional Formatting" may not work for this...

Add the following code to the Forms "On Current"
Procedure: -

'Colours fields to Red if not null, colors fields black if
they are null
'Repeat each line for each field that is to be coloured
if me.field1 <> "" then me.field1.backcolor=255 else
me.field1.backcolor=0

HTH

Tony C

 

[Wayne Morgan]

Set it for an expression and try

IsNull([NameOfControl])

 

[Guest]

Thank you! That is exactly what I needed!

-----Original Message-----
Set it for an expression and try

IsNull([NameOfControl])

--
Wayne Morgan
Microsoft Access MVP

I'm trying to make a text box on a form highlight if the
user does not enter data. I tried to use conditional
formatting, but do not know what to enter as my
expression for "blank field" Any Thoughts?

.