Re: Year only in field

Tech-Archive recommends: Fix windows errors by optimizing your registry

Tim, use a Number field (size Integer), not Text.
Text is less effienct, and doesn't sort/select correctly, and
can contain non-numeric characters.

Done.

To ensure a sensible (4-digit) number is entered, set these
properties on the field:
Validation Rule: Is Null OR Between 1000 And 2999
Validation Text: Enter a 4 digit year

Ah, I have never done something like that. This would work.


BTW, don't name the field YEAR. This is a function name, and
in certain contexts (forms, reports), Access will
misunderstand what you are talking about. Use something such
as TheYear, BirthYear, IncidentYear.

Yes, I have the field named EventYear.

Thank you Allen (and you too Bonnie) for the help in this.

Tim



.