467,116 Members | 1,224 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,116 developers. It's quick & easy.

Conditional Formatting in a Form

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
  • viewed: 4082
Share:
2 Replies
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
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.

Similar topics

4 posts views Thread by Bradley | last post: by
2 posts views Thread by Von Bailey | last post: by
5 posts views Thread by Andrew Chanter | last post: by
reply views Thread by GGerard | last post: by
4 posts views Thread by midlothian@gmail.com | last post: by
2 posts views Thread by Filips Benoit | last post: by
1 post views Thread by Earl Anderson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.