setting validation rules in Access 2003

[gchaves]

I am trying to set a validation rule for my Year field so that it will only accept years that are greater than or equal to 2004 (ex. >=2004). My field is set as a number, yet when I enter >=2004 in my validation rule, it does not seem to work. Can anyone please help?

Thanks...G

 

[willir]

If you are having the end user enter a date, then try
> #12/31/2003#

You can also use the same approach with the BeforeUpdate event procedure.

If Year(Me.YourDateField) < 2004 then
Cancel = True
End If

Richard

 

[pbrodsky]

It works the way you did it in Access 2002.