How to format a table field for "year", only with 4 digits but enter only two?

[everterra]

How to create a year field, only with 4 digits in a table and enter only two?




To be able to work quickly, I want to enter only two digits, 13, and the field value in the table is shown as 2013.


I'm trying this: In the table named DOCS I have a field, YEAR looking (lookup) in another table:

I enter 13, but it must show the value in the 2nd column, 2013
In a query or a form it´s easy, but in a table field (DOCS) how to get it?


Can be used an Expression in the properties, Data Type> Calculated?

It is possible to

• create a query here?
• or use the DLookup function?

How?

[June7]

I use input mask and have the '20' part actually saved in the record. I know Y3K is a long way off and Y2K wasn't really the major disaster everyone expected, but saving the 20 is just convenient and memory is cheap.

Year is a reserved word in Access and reserved words should be avoided as field names.

[everterra]

Resolved: I created the YEAR field (named ANO), type number, and in the input mask I put "20" ##.
Now I enter only 13 and turns to 2013.


Thanks June7.