Please help with Conditional Formatting

How do I write in Conditional Formatting It is not Null. This is what I have
and it is not working: IF(IsNotNull([CONTROL NAME])) - text different
color. Any help will be greatly appreciated. Thank you.

Set the Condition to:

Expression [Control Name] Is Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TotallyConfused" wrote in
message
...
How do I write in Conditional Formatting It is not Null. This is what I
have
and it is not working: IF(IsNotNull([CONTROL NAME])) - text different
color. Any help will be greatly appreciated. Thank you.

Thank you for responding. But I want my font to turn grey (I know how to do
the color) if my field has a date entered. That is why I said Is not Null.
Or how do I write that if the field has a date entered (it could be any date)
then I want my field to be greyed out. If it is empty then I want it red and
bolded (I can do the red and bold) I can't do "Is not Null". Thank you.

"Allen Browne" wrote:

Set the Condition to:

Expression [Control Name] Is Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TotallyConfused" wrote in
message
...
How do I write in Conditional Formatting It is not Null. This is what I
have
and it is not working: IF(IsNotNull([CONTROL NAME])) - text different
color. Any help will be greatly appreciated. Thank you.

Well, you have me totally confused too.

Null means there's nothing there in the text box.

Nothing in bold, red text won't be very visible, will it?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TotallyConfused" wrote in
message
...
Thank you for responding. But I want my font to turn grey (I know how to
do
the color) if my field has a date entered. That is why I said Is not
Null.
Or how do I write that if the field has a date entered (it could be any
date)
then I want my field to be greyed out. If it is empty then I want it red
and
bolded (I can do the red and bold) I can't do "Is not Null". Thank you.

"Allen Browne" wrote:

Set the Condition to:

Expression [Control Name] Is Null

"TotallyConfused" wrote in
message
...
How do I write in Conditional Formatting It is not Null. This is what
I
have
and it is not working: IF(IsNotNull([CONTROL NAME])) - text different
color. Any help will be greatly appreciated. Thank you.

Okay - I am not explaining myself correctly. If date field 1 has a date,
than I want date field 2 to be greyed out. If date field 1 is empty, than I
want date field 2 to be bolded in red font. Does this make sense. Thank you
again for your help.

"Allen Browne" wrote:

Well, you have me totally confused too.

Null means there's nothing there in the text box.

Nothing in bold, red text won't be very visible, will it?

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TotallyConfused" wrote in
message
...
Thank you for responding. But I want my font to turn grey (I know how to
do
the color) if my field has a date entered. That is why I said Is not
Null.
Or how do I write that if the field has a date entered (it could be any
date)
then I want my field to be greyed out. If it is empty then I want it red
and
bolded (I can do the red and bold) I can't do "Is not Null". Thank you.

"Allen Browne" wrote:

Set the Condition to:

Expression [Control Name] Is Null

"TotallyConfused" wrote in
message
...
How do I write in Conditional Formatting It is not Null. This is what
I
have
and it is not working: IF(IsNotNull([CONTROL NAME])) - text different
color. Any help will be greatly appreciated. Thank you.

1. In form design view, select your Date2 field

2. Choose CF on the Format menu.

3. Set Condition 1 to :
Expression [Date1] Is Null
and choose the red font and bold icon.

CF cannot disable the field, so to give the greyed out appearance, you would
just choose the grey A on the toolbar in form design view.

(If there are actually more of these date fields, it may indicate that you
need a related table where you have many related records (one date in each
record) instead of many fields in this table.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TotallyConfused" wrote in
message
...
Okay - I am not explaining myself correctly. If date field 1 has a date,
than I want date field 2 to be greyed out. If date field 1 is empty, than
I
want date field 2 to be bolded in red font. Does this make sense. Thank
you
again for your help.

"Allen Browne" wrote:

Well, you have me totally confused too.

Null means there's nothing there in the text box.

Nothing in bold, red text won't be very visible, will it?

"TotallyConfused" wrote in
message
...
Thank you for responding. But I want my font to turn grey (I know how
to
do
the color) if my field has a date entered. That is why I said Is not
Null.
Or how do I write that if the field has a date entered (it could be any
date)
then I want my field to be greyed out. If it is empty then I want it
red
and
bolded (I can do the red and bold) I can't do "Is not Null". Thank
you.

"Allen Browne" wrote:

Set the Condition to:

Expression [Control Name] Is Null

"TotallyConfused" wrote in
message
...
How do I write in Conditional Formatting It is not Null. This is
what
I
have
and it is not working: IF(IsNotNull([CONTROL NAME])) - text
different
color. Any help will be greatly appreciated. Thank you.

BTW,

IsNotNull

isn't a VBA function! Correct syntax for this in VBA would be

Not IsNull

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com