Input Mask

C

Chi

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
 
F

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top