Conditional Formatting in a Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jerry.ranch@pioneer.com - 12 Jan 2006 17:20 GMT

I am full of ??'s today.
I've been working on this one for a few weeks now and haven't been
able to figure it out.

I have a form that pulls data from a query.
I want the background of one of the field cells to be red if the value
in the field is null.

Can't seem to get this done with the conditional formatting available

Jerry

Reply to this Message

fredg - 12 Jan 2006 18:47 GMT

> I am full of ??'s today.
> I've been working on this one for a few weeks now and haven't been
[quoted text clipped - 7 lines]
>
> Jerry

What have you tried so far?

Select the control on the form.
Click on Format + Conditional Formatting
Set the Condition1 drop-down to
Expression Is
Write
[FieldName] Is Null
in the next box
Set the color to red.
Click OK

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

jerry.ranch@pioneer.com - 12 Jan 2006 20:59 GMT

Tried lots of stuff, except what you suggested
= null
=""
all the operators in combinations with "is null"

Never saw the "expression is" and wouldn't have thought to use
[fieldname] is null as an expression

But it WORKS LIKE A CHARM

Thanks
Jerry

>What have you tried so far?
>
[quoted text clipped - 7 lines]
>Set the color to red.
>Click OK

Reply to this Message