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
  • 3
  • 2
  • 2
LVL 65

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 65

Expert Comment

by:Jim Horn
ID: 17083796
Where are you at with this right now?
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help writing a query 6 73
is there a opposite on ON CURRENT in ms/access 15 34
Alter an update query which rounds 7 33
Access Excel export not behaving 2 27
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now