Input Mask – short date? (Access 97 or 2000)

Topic

New Reply

I am trying to set an input mask for a 4-digit date. I only want users to type in the month and day, not the year (mm/dd). Is there any way to do this? Probably basic, but I’m stumped. Thanks.

Reply | Quote

Replies

Try setting the form (or table) field’s format property to “mm/dd/yy”. If the user types in “7/27” and or , “07/27/01” will be displayed (the current year will be assumed). No input mask required. Of course, this does assume you WANT the current year.

Reply | Quote

No, actually the problem is I want no year.

Reply | Quote

go to table design and set the fields format to mm/dd

Reply | Quote

Thank you Jerry. I think that will work. I knew the solution couldn’t be that hard. The field is for birthdays and I don’t want to display years or even have users enter a year.

Reply | Quote

In that case, why bother storing it as a date at all? You could easily store it as text and create an input mask for that.

Reply | Quote

You can’t save a date without a year, you can only format it to appear that way. However, it isn’t something I recommend because you have no visual check to make sure the user hasn’t done something creative with his system date that will make nonsense of your data.

Reply | Quote