Conditional Formatting

  • Thread starter Thread starter Kembo
  • Start date Start date
K

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?
 
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
 
Back
Top