robhas
asked on
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.
Tried to remove mask from database but still get the same result.
try to remove the mask from the database.
ASKER
Removed the mask from the field in the database but it still happens.
ASKER
Edited text of question
can you provide me with the code ,
to Hanzala@rocketmail.com
to Hanzala@rocketmail.com
Try Setting The Input Mask To 99/99/99;0;_
ASKER
Not the solution, still working at it.
for date
set the format ddddd
and mask is ##/##/##
Now try it.
ASKER
Does not work.
Try ##/##/## ##:##
ASKER
This answer does not work either.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It gave me very close to what I needed.