Conditional Formatting in a Form

[jerry.ranch]

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

[fredg]

On Thu, 12 Jan 2006 11:20:51 -0600, je*********@pioneer.com wrote:

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

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

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

[jerry.ranch]

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?

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