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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top