Problem with date field

[fatboy95]

Not sure if this is the correct forum sorry if I am wrong.

I have a date field in access that I want it to do two things. I would like it to display the Month and year ie; Feb, 05. I know access is tricky with this but nothing I do will work.

The second thing I would like it to do is if the date is within 60 days of current date for the font color to be red.

Thanks for the help

 

[pbaldy]

Not tricky; look at the Format() function.

In a form or report, this can be done with conditional formatting in Access 2000 or later.

 

[Debased]

Something like this should work.


SurveyDate.Format = "mmm yy"

If SurveyDate > Now() + 60 Then

SurveyDate.BackColor = 255

Else: SurveyDate.BackColor = -2147483643

End If

 

[fatboy95]

I guess I didn't explain everything out. I am using a contionous form that has the date for each eng is due. I need to be able to see which engine is due within 6 months and if it is have the background or font turn red. Thanks for the help it has gotten me a little ways but trying to make each engine date turn red individually per the date.

 

[pbaldy]

Did you look at conditional formatting, which will do what you ask?

 

[fatboy95]

Looking at conditional formatting now.... If I am thinking correctly I am going to have to reference the engineID and check the date that way.

 

[fatboy95]

Found the answer!

Just wanted to post that I found the answer to my problem. It sure was a lot easier than I thought it would be. Hopefully it isn't a problem posting a link to the website I found it at.

http://www.cse.dmu.ac.uk/~mcspence/New features.htm#Conditional formatting