using format func. to validate time for textbox

[shastri_s]

How do I use the Format func. and the Isdate func. to validate the time for a textbox.
Rightnow it works for date or time formats , but I want it for only Time format(hh:mm:ss).


Any ideas , anybody.

Thanks

[Yonatan]

Try this to make sure the TextBox has nothing but the Time:

Text1.Text = Format(CDate(Text1.Text), "Long Time")

You can also try "Medium Time" and "Short Time" - see how all three work, and decide which is best for you.

------------------
Yonatan
Teenage Programmer
E-Mail: RZvika@netvision.net.il
ICQ: 19552879 (http://www.icq.com/19552879)