Format date automatically in text box

[Bebe]

I have a group box in my program where the user inputs a date they are suppose to type it in this format mm/d/yy; there is no error routine if they don't do it i have just limited the characters this data then is updated to a database that uses that particular field. I am using the databound control and hook that field up to it's corresponding field in my database. Is there a way that i can have the box automatically format the date or prompt them if it's not entered correctly; anyone have any ideas on how they would do this. I need to gurantee that i always have an accurate response go to the database.

thank you !!!

[kedaman]

Try to use CDate and isdate functions

[Bebe]

sorry not a group box a text box; lol

[Bebe]

used the date time picker control in vb6 works great in the properties you can automatically format the date!!!