Please help with Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TotallyConfused - 16 Mar 2007 06:49 GMT

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.

Reply to this Message

Allen Browne - 16 Mar 2007 08:04 GMT

Set the Condition to:

Expression [Control Name] Is Null

Signature

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.

> 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.

Reply to this Message

TotallyConfused - 16 Mar 2007 08:30 GMT

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:
>
[quoted text clipped - 4 lines]
> > and it is not working: IF(IsNotNull([CONTROL NAME])) - text different
> > color. Any help will be greatly appreciated. Thank you.

Reply to this Message

Allen Browne - 16 Mar 2007 08:35 GMT

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?

Signature

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.

> Thank you for responding. But I want my font to turn grey (I know how to
> do
[quoted text clipped - 15 lines]
>> > and it is not working: IF(IsNotNull([CONTROL NAME])) - text different
>> > color. Any help will be greatly appreciated. Thank you.

Reply to this Message

TotallyConfused - 16 Mar 2007 08:44 GMT

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.
>
[quoted text clipped - 21 lines]
> >> > and it is not working: IF(IsNotNull([CONTROL NAME])) - text different
> >> > color. Any help will be greatly appreciated. Thank you.

Reply to this Message

Allen Browne - 16 Mar 2007 09:03 GMT

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.)

Signature

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.

> 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
[quoted text clipped - 33 lines]
>> >> > different
>> >> > color. Any help will be greatly appreciated. Thank you.

Reply to this Message

missinglinq - 16 Mar 2007 13:42 GMT

BTW,

IsNotNull

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

Not IsNull

Signature

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

Answers/posts based on Access 2000

Reply to this Message