Conditional formatting question

S

Sue

I want a data entry fiel on my form to have a background color when it is a
null value to alsert the user that information is required. Can't seem to
figure that out.

If that isn't possible, I'd like the associated label to be conditionally
formatted for the same reason.

Can do?

Appreciate the help!
 
B

Beetle

Under Conditional Formatting put;

Expression Is: [NameOfYourControl] Is Null

Then choose the background color you want.
 
S

Sue

PERFECTO!
Thanks.
--
Thanks for your time!


Beetle said:
Under Conditional Formatting put;

Expression Is: [NameOfYourControl] Is Null

Then choose the background color you want.
--
_________

Sean Bailey


Sue said:
I want a data entry fiel on my form to have a background color when it is a
null value to alsert the user that information is required. Can't seem to
figure that out.

If that isn't possible, I'd like the associated label to be conditionally
formatted for the same reason.

Can do?

Appreciate the help!
 

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

Top