Please Help!! NOT IsNull in Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TotallyConfused - 19 Mar 2007 06:49 GMT

I am sorry to have to post again. But I have not had any luck with
Conditional Formatting. I have tried: If isnull([Date field 1]) and [Date
field 1] Is Null, "", Not Null, etc.

I have two date fields. Date 1 and Date 2. I have a condition set for date
1 to read - field Value is Less than Date(). Font is red meaning it is
overdue. When Date 2 is entered (date when received), I want Date 1 to be
greyed. Meaning if there is no Date in Date 2 then Date 1 should be red. If
a date is entered in Date 2 then Date 1 date should be greyed. I feel that
this should be feasible and probably easy to do but I can't get it to work.

Any help will be greatly appreciated. Thank you.

Reply to this Message

Hansford cornett - 19 Mar 2007 12:54 GMT

You may want to use Nz([DateField1],0) to detect NULL I find it works much
better.

this causes the field DateField1 to be set to 0 and then do your IF THEN
statement based on if the field is ZERO or not zero... I believe this should
suit your need and work for you.

Dwight

Signature

Hansford D. Cornett

> I am sorry to have to post again. But I have not had any luck with
> Conditional Formatting. I have tried: If isnull([Date field 1]) and [Date
[quoted text clipped - 8 lines]
>
> Any help will be greatly appreciated. Thank you.

Reply to this Message

TotallyConfused - 19 Mar 2007 14:23 GMT

Hi Thank you for responding. Can you please tell me how to write the IF then
statement?

> You may want to use Nz([DateField1],0) to detect NULL I find it works much
> better.
[quoted text clipped - 17 lines]
> >
> > Any help will be greatly appreciated. Thank you.

Reply to this Message