>I need to collect time data in a form, I am interested in hearing ideas on how to do that. I know it can be entered in a textbox, but I would prefer to use a combobox or something even neater. I tried using the combobox but couldn't get it to work by using a row source of values such as, 1.00, 1.15, 1.30 etc.
>
>Please let me know how to make the combobox work, or give me your ideas on how to input time on a form in the neatest way.
>
>Thanks
You can enter time into textbox with
.Inputmask="99:99:99"
After the value is entered you can validate it (hours<=24,minutes/seconds<=60) and transform into Datetime datatype e.g.:
cEntered=dtoc(date())+" "+thisform.text1.value
tEntered=ctot(cEntered)
Edward Pikman
Independent Consultant