Input mask messed up my field data type

[ghostmachine]

hi



i have a date/time field called MyDate. Originally, its format is mm/dd/yyyy and there is no input mask. The Date Picker is also set. I then added input mask using Short date (99-99-0000;;_) and change the format to mm-dd-yyyy. However, when i switch to DataSheet view , all my dates are changed from mm/dd/yyyy to mm-dd-yyyy (which is the correct behaviour right? ) and when I tried to enter a new date in it says "The value you entered does not match Date/Time data type in this column". Plus, the DatePicker is missing. How can I resolve this. thank you

[NTC]

A mask undoes date picker. It is one or the other. That's the first point.

In terms of masks; it can be either at the table level or the form/control level - and it isn't clear which you are discussing. So if the mask is important - please clarify.

[ghostmachine]

thanks. its at field level. just one field called MyDate as i had indicated in my question. Its originally set to Date/Time data type. After input mask is applied, the error comes out when i try to change the date values.