Mask Edit Control & Date

I have a field in an Access database set as a date and with a mask as date mm/dd/yy. On my app I have a masked edit control set to retrieve this field the mask property is set to 99/99/00;0; and the format to mm/dd/yy.  When I run my app it will display 11/24/_8 if the year is set to 98 in the database. If I turn the 98 to 68 it displays fine in the control.  When debugging booth the mask and the database field say 11/24/98. What could be the problem? Thanks.
Tried to remove mask from database but still get the same result.
robhasAsked:
Who is Participating?
 
bear454Connect With a Mentor Commented:
forget the masked edit, use format(value,"Short Date") to represent the data in a standard textbox or label.
If you need to do fomatted input as well, break it into separate text boxes for month, day & year - Use month(value) day(value) and year(value) to return the separate parts of the date.
0
 
InteqamCommented:
try to remove the mask from the database.

0
 
robhasAuthor Commented:
Removed the mask from the field in the database but it still happens.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
robhasAuthor Commented:
Edited text of question
0
 
InteqamCommented:
can you provide me with the code ,
to Hanzala@rocketmail.com

0
 
BC111398Commented:
Try Setting The Input Mask To 99/99/99;0;_
0
 
robhasAuthor Commented:
Not the solution, still working at it.
0
 
neelam_sCommented:

 for date
set the format ddddd
and mask is ##/##/##
Now try it.

0
 
robhasAuthor Commented:
Does not work.
0
 
MirkwoodCommented:
Try  ##/##/## ##:##
0
 
robhasAuthor Commented:
This answer does not work either.
0
 
robhasAuthor Commented:
It gave me very close to what I needed.
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.

All Courses

From novice to tech pro — start learning today.