Conditional formatting in access 2007

[Bob H]

I am trying to get conditional formating to change the text colour of a
particular date, but can't see what syntax to use.

I have a form with a field called 'Next Test Date' which is empty, but
when I run a query it is filled in as required from Next Test Date:[Last
test Date]+ 365. Last Test Date is also a field in the form and the
dates are filled in.
So if last test was say 05/12/07, then next test date is 05/12/08.
What I want is to change the colour of the text if the next test date is
say less than 90 days away.
I can do this in Excel, but not in Access 2007.

Thanks

 

[Steve Schapel]

Bob,

I think the expression would be:
[Next Test Date]-Date()<90

Alternatively:
DateDiff("d",Date(),[Next Test Date])<90

 

[Bob H]

Bob,

I think the expression would be:
[Next Test Date]-Date()<90

Alternatively:
DateDiff("d",Date(),[Next Test Date])<90

Thanks Steve, the first one works a treat.