Access 2007 - input mask for date
Posted on 2011-09-12
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
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:
On Key Press(Event Proc)...
how can I fix the problem with End date field?
Thanks in advance