conditional formatting

[lynn atkinson]

I have a sub form in which I want to Display overdue
dates. The calculation is carried out in the query and the
resulting field placed in the form. This field is then
conditionally formatted to display in RED if it is due in
the next 30 days or overdue (condition: if field value is
less than Date()+30)
However, the displayed results are not correct in that
some overdue courses are not appearing in red and some
courses that are not quite due are in red.

I am using Access 2002 SP1.

(This seemed to work until I put an IIF statement into the
calculated field. Has this made it too complicated?)

the calculation is

calc date due: IIf([qualification duration]=0,"no refresh
req",Max((DateAdd("m",[course details]![qualification
duration],[event schedule]![eventdate]))))

 

[lynn atkinson]

As an update to this problem, I have discovered if I take
the IIF statement out of the calculated date field, then
it works OK. If I put IIF part back in, it stops working.
Any way round it?