Input Mask

[sthapa]

does anyone know how to make an input mask that allows you to enter the 01/03 as in mm/yy into a date field, for issue date and expiry date of criedit cards?

 

[ghudson]

Your challenge is you are not storing a true date [mm/dd/yyyy]. Also, you can not use an intput mask on a text field. You could create a separate field for the month and another field for the year. Perhaps somebody else has had to create an app with credit card info and they can share their ideas.

 

[monkeytunes]

Could you just designate "mm/yyyy" in the Format property of the field storing the expiration date? I've found that when you use a Date/Time field, you can just put in "mm/yyyy" or what-have-you for the format instead of using one of the pre-formed "short date/long date/etc" options. While Access will put in a default "01" for the day, you won't have to see it.