Solved

Customize input mask for date field

Posted on 2006-07-11
7
327 Views
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.

Arethea
0
Comment
Question by:lynnell35
  • 3
  • 2
  • 2
7 Comments
 
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.

-Jim
0
 

Author Comment

by:lynnell35
ID: 17083776
How would i do this?

0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 17083796
Where are you at with this right now?
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 65

Accepted Solution

by:
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


0
 
LVL 65

Expert Comment

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

Author Comment

by:lynnell35
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.



0
 
LVL 65

Expert Comment

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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

828 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