Conditional formatting in access 2007

  • Thread starter Thread starter Bob H
  • Start date Start date
B

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
 
Bob,

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

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

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

Alternatively:
DateDiff("d",Date(),[Next Test Date])<90
Click to expand...

Thanks Steve, the first one works a treat.
 
Back
Top