Input Mask

[Guest]

Hi,

The short date input mark is 99/99/0000;0; _. Therefore, I need to enter
the date/ month/year in the table.

Would you show me what is the input mask if I wanted to enter the year only?


Thanks
Chi

 

[fredg]

Hi,

The short date input mark is 99/99/0000;0; _. Therefore, I need to enter
the date/ month/year in the table.

Would you show me what is the input mask if I wanted to enter the year only?

Thanks
Chi

Sorry, a year is not a valid entry for a Date/Time datatype field.

A valid date entry for a Date/Time field must include a month day and
year.
Access will guess (if you don't use an Input Mask) if you enter 1/5
that you mean 1/5/2006 (the current year) or if you enter 7/2006 you
mean 7/1/2006, but there is no way to simply enter 2006 as a valid
date.

If you only want the Year, than change the field datatype to Integer.

Perhaps you should let us know why you want to do this, and someone
will tell you how.

 

[Guest]

Thanks Fred,
Your response is very helpful to me.

Chi