[AccessD] Conditional Formatting

[Rocky Smolin]

Dear List:

Client has a requirement to show different colors in a date field (fldBidJob
*Anticipated*InspectionDate):

1) if today's date is within 5 days make the backcolor of fldBidJob
*Anticipated*InspectionDate yellow,

2) if today's date is within 3 days make the backcolor of fldBidJob
*Anticipated*InspectionDate red,

3) if another field (fldBidJob*Actual*InspectionDate) is a date then make
the backcolor white (IOW, of the inspection has been done, no color in the
anticipated inspection date)

For conditional formatting for req't. 1 I use Expression is:
      Date()>=DateAdd("d",[fldBidJobAnticipatedInspectionDate],-5)
Works well.

For conditional formatting for req't. 2 I use Expression is:
      Date()>=DateAdd("d",[fldBidJobAnticipatedInspectionDate],-3)
Also works well.

For conditional formatting for req't. 3 I use Expression is:
      IsDate([fldBidJobActualInspectionDate])

Doesn't work. The backcolor of  fldBidJob*Anticipated*InspectionDate
remains red when there is a date in fldBidJobActualInspectionDate.

The three conditions are stacked 1) red first, 2) yellow second, 3) white
third.

If I have only the first two conditions they both work well.

I can't figure out why the last condition doesn't work.