By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,034 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Conditional Formatting in a Form

P: n/a
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
Jan 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jan 12 '06 #2

P: n/a
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


Jan 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.