dukeslater
Technical User
VB6 app using an Access 97 datasource.
We've had some problems with users entering invalid dates, so I wanted to change the text box to a MaskEdBox so that I can define a mask.
At runtime if no mask is defined then the dates stored in the database are reflected properly. However, regardless of the various mask formats I try, once the mask is defined then no data appears.
Every date in the database is stored as m/d/yy, and there is no mask defined in Access
It seems that if there were no records stored already the process would be simple. But how can I determine the proper format to work with the data I already have?
For other reasons I don't want to use a datetime picker here.
I appreciate any help you could give.
We've had some problems with users entering invalid dates, so I wanted to change the text box to a MaskEdBox so that I can define a mask.
At runtime if no mask is defined then the dates stored in the database are reflected properly. However, regardless of the various mask formats I try, once the mask is defined then no data appears.
Every date in the database is stored as m/d/yy, and there is no mask defined in Access
It seems that if there were no records stored already the process would be simple. But how can I determine the proper format to work with the data I already have?
For other reasons I don't want to use a datetime picker here.
I appreciate any help you could give.
