Customize input mask for date field

Posted on 2006-07-11
Last Modified: 2012-05-07
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.

Question by:lynnell35
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 66

Expert Comment

by:Jim Horn
ID: 17083642
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.


Author Comment

ID: 17083776
How would i do this?

LVL 66

Expert Comment

by:Jim Horn
ID: 17083796
Where are you at with this right now?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 65

Accepted Solution

rockiroads earned 125 total points
ID: 17085130
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

LVL 65

Expert Comment

ID: 17088127
thanks lynnell35
I wonder though if some credit should go to Jim since he suggested u use the format property

Author Comment

ID: 17089895
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.

LVL 65

Expert Comment

ID: 17096995
Raise a question in community support asking them to reopen this so u can award points accordingly

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question