Got a richtextbox control. Users are entering dates into this thing. Now, I need to make sure that the date that gets entered into my database is in the following format - dd/mm/yyyy - regardless of what the users enter into the control. as long as they enter a date, the code should convert it into what I want. I have tried the following but it always returns the current date, which is not what is required.
.text = format(Date,"dd/mm/yyyy")
Is it possible to have a mask in the control, sort of grayed out in the background, that will guide the user on how to enter the date? Or is it best to just validate the hell out of what the users enter and then convert it to what I need? Former probably simpler, latter most definately harder.
Using VB6 Enterprise, sp6 and access 2003.