Conditional Formatting - Newer mm/dd/yy make color??

[Cameroncha]

All i want to do is to make my Release field a different color if it is new than a certain date....

I have used Conditional Formatting for fields that are common ( formats >>> V, or D, ect. but i dont understand how to use Conditional formatting for a date range

I've tried this: >06/01/02 in the greater than field given for conditional formatttin but nothing happens. . . It looks like i need to use an expression and tried Date( >06/01/02 ) but i get an expression error.

I know, I know .... that code is way off. It just seems so simple, any suggestions.


So far i haven't used any VB on my database (at least anything that i have coded by hand) and still pretty new to Access.

Thanks.

 

[Rich]

Try >#06/01/02#

 

[Cameroncha]

This works great with Office XP edition but not on Office 2000 edition

Is there a way to do this without conditional formatting so that i can get it to work in Office 2k ? ?

 

[Rich]

I thought A2K had conditional formatting, but you could use
If Me.MyDateField >#06/01/02# Then
Me.SomeOtherField.ForeColor =vbRed
Else
Me.Me.SomeOtherField.ForeColor =vbBlack
End If
in the On Format event

 

[Cameroncha]

It does, but when i enter >#06/01/02# into the Conditional formatting field nothing happens on 2k Office.

Strange, it doesn't give any error messages just doesn't display the formatting.

 

[Rich]

Have you tried using the four part year #06/01/2002# ?