>I have a database where all the dates are stored as C fields, yyyymmdd.
>
>I need a _Textbox class that will display the date as mm/dd/yyyy and accept
>dataentry in that format then switch it back to yyymmdd b4 the tableupdate.
>
>I would appreciate any suggestions as to ways to accomplish it, is it
>perhaps a part of some user libs here?
>thanks all
>
>bill
Leave textbox controlsource empty and set it value to {} (so it would be date textbox). In it's refresh put this.value = ConvertCharToDate(myTable.myCharDField)
in its lostfocus put
replace myCharDField with dtos(this.value)
If it's not broken, fix it until it is.
My Blog