Dates

  • Thread starter Thread starter Glenn Brown
  • Start date Start date
G

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
 
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
 
Back
Top