Entering Date in Database through Mask Edit Textbox

[wey97]

I am connecting to a database through an adodc control.
I have a maskedit box and I am trying to enter a date into the database. It works fine without the mask property set, but when I set the mask to ##/##/#### , I cannot enter the date into the record. By the way my regional date setting is set to the four digit year. Please help...

[Paul Warren]

The problems you're experiencing are because the masked edit box is crap. It doesn't handle dates+masks very well. When I've used it I just set the .Format property to a date value and don't enter any mask. This gives you more control than a normal text box but doesn't give any problems with the mask. If you want to use the mask you might try using CDate(Box.Text) before putting the value into the database.

Hope this helps.