Just a Year format on the form, not usual date format (1 Viewer)

[saledo2000]

Hi everybody,
I have one little problem. I want to set format on the field Year of Birth where I record only a Year when the person is borne (without day and month). How to set only a Year format when I edit the date type format in the table, I see only Access standard date format types and do not know how to add custom format. I get error that field is empty when I want to save my custom format in input mask for the year only.

Thank you

 

[theDBguy]

Hi. If you're using a Date/Time data type, then your field also needs the month and day with the year. If you really only want to store the year, then you need to use a Number data type.

 

[Minty]

A Year value on it's own isn't a date, it's simply a number.