Dates

[Glenn Brown]

I have a field within a table where I want to enter the year only (e.g.
2003). Access XP doesn't seem to like this. Tried using different formats
etc with no success. Any ideas?

Glenn

 

[Allen Browne]

Use a field of type Number.
In the lower pane, set the Size to Integer.
If you want to make sure the person enters a 4-digit year, set a suitable
range in the field's Validation Rule, e.g.:
Is Null OR Between 1900 And 2100