Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

Access 2007 - input mask for date

Hi,

I have date field in my access form which is connected to sql server.

Th properties of End Date field is:

Data: controlsource: MyDate
Input Mask: 00/00C9999;0;0
Event: BeforeUpdate: EventProc
AfterUpdate: EventProc
All: Control Source: MyDate

I keep entering date like: 07/01/2010 but it keep saying that mydate is not matching with inputmask format. I have another startdate field which works fine and the only difference for startdate is in event:
BeforeUpdate (EventProc)
On Key Press(Event Proc)...

how can I fix the problem with End date field?

Thanks in advance
0
shmz
Asked:
shmz
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Over the years, I have found for the most part, users hate date input masks.  I would suggest ... no date input mask.

For any date in the current year, at most ... the user only has to type mm-dd and hit Enter or Tab.  The current year will automatically added.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
As far as the Input Mask, I would suspect you want this:

00-00-0000;0;_

mx
0
 
Gustav BrockCIOCommented:
> Over the years, I have found for the most part, users hate date input masks.

Exactly. They seem to add more trouble and confusion than the error message that pops should the user type something not readable as a date.

/gustav
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
peter57rCommented:
There is no difficult data entry problem which cannot be transformed by the judicious use of an input mask ................................................................................................................................................... into a problem which is a thousand times more difficult!!
0
 
Richard DanekeTrainerCommented:
as relates to your question:
  Why does the End Date call the EventProc afterUpdate and the Start Date call the same EventProc before update?
0
 
shmzAuthor Commented:
DoDahD:

I am not familiar with access and I haven't created the form so I appreciate if you let me know what happens as a result of this setting?
0
 
shmzAuthor Commented:
Thanks
0
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now