[AccessD] Conditional Formatting

[Rocky Smolin]

That was gonna be my next question. Thank you.

r

On Tue, Aug 13, 2024 at 9:09 AM Stuart McLachlan via AccessD <
accessd at databaseadvisors.com> wrote:

> Multiple conditions on one field are like a Select Case.
> Once a condition is satisfied, no furhter conditions are tested.
>
> Either:
> 1 Change the order so that you test for ActualInsepctionDate first.
> or
> 2. Only have two conditions and make them:
> Date()>=DateAdd("d",[fldBidJobAnticipatedInspectionDate],-5) AND NOT
> ISDATE(...)
>
>
>
> On 13 Aug 2024 at 7:53, Rocky Smolin wrote:
>
> > 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.
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>