Date/Time format in years only ?

[andyw]

Hi,

I want to change the Date/Time format property so it displays just the
year, I've tried yyyy but that does'nt seem to work.

Any idea's ?

 

[Allen Browne]

Setting the Format property to yyyy should display the year only, until the
field gets focus. Then Access will show the whole thing, because that's the
only thing that would make sense for data entry.

If you want a field that contains the year only, use a Number field, not a
Date/Time field.

 

[andyw]

thankyou, I understand now.