year field

[Guest]

Hello

I was wondering how would be the best way to check for a valid year field on a form

Rodney

 

[Marshall Barton]

I was wondering how would be the best way to check
for a valid year field on a form?

Is this ever a vague question or what. What do you think is
a "valid" year?

Access date fields accept dates from 1/1/100 to 12/31/9999,
so if that's all you want then the IsDate function will
probably do it.

If you want to limit dates to a small range, then you could
use the text box's Validation Rule property to check if the
date is in the allowable range.

. . .
. . .
. . .

Maybe you could provide more details so we don't have to
speculate about whatever it is you're looking to do here.

 

[Guest]

Ok, I have a year field where I want a user to put in a 4-digit year. I guess I'll use the range 1900-9999.

 

[Marshall Barton]

Ok, I have a year field where I want a user to put in a 4-digit year. I guess I'll use the range 1900-9999.

In that case, either the form text box's or the table
field's Validation rule can be used (normally the table
field is where this should be enforced).

Just it to: Between 1900 And 9999

Don't forget to set the Validation Text property to the
error message you want to see when an invlaid year is used.

Is there really any chance you will have valid data beyond
the 21st century?

 

[Guest]

Thanks for the info.

 

[Guest]

No, I probably won't validate passed the 21st. Thanks for the information.