Customize input mask for date field

I have a table that I have linked to a table.  I want the date field to display the date as "mmm, yy" i( Jan 06) instead of the short date (01/01/2006).

How can i do this?

Any help is appreciated.

Who is Participating?

Improve company productivity with a Business Account.Sign Up

rockiroadsConnect With a Mentor Commented:
As Jim says, u can modify the field on a form

If u open a form, go in design view, select your field and look at its properties
there is one called Format

u can pick a predefined one or make your own

e.g. a format specified like this

mmm", "yy

will display Jan, 06

Bear in mind though, if this field is editable, then u will lose this format when that field gets focus. but reverts back when u lose focus

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
You can't change the table schema of a linked table, only at the source table.

You can change the way it appears in forms by editing the Format property of a control that is bound to your date field.

lynnell35Author Commented:
How would i do this?

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Where are you at with this right now?
thanks lynnell35
I wonder though if some credit should go to Jim since he suggested u use the format property
lynnell35Author Commented:
Yes, thanks you.  I would like to split the points between the both of you.   Sorry Jim, when i finally got around to opening this message i was in such a rush that just saw the code and clicked accept.

Once again thanks for all of your help.  I don't know what i would do with out you gusy.

Raise a question in community support asking them to reopen this so u can award points accordingly
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.