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
Printable View
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
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: [email protected]
ICQ: 19552879