Please help with Conditional Formatting

[Guest]

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.

 

[Allen Browne]

Set the Condition to:

Expression [Control Name] Is Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Guest]

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.

Set the Condition to:

Expression [Control Name] Is Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

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.

 

[Allen Browne]

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

Reply to group, rather than allenbrowne at mvps dot org.

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.

Set the Condition to:

Expression [Control Name] Is Null

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.

 

[Guest]

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.

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

Reply to group, rather than allenbrowne at mvps dot org.

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.

Set the Condition to:

Expression [Control Name] Is Null

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.

 

[Allen Browne]

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

Reply to group, rather than allenbrowne at mvps dot org.

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.

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?

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.

:

Set the Condition to:

Expression [Control Name] Is Null

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.

 

[missinglinq via AccessMonster.com]

BTW,

IsNotNull

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

Not IsNull