Format textbox_exit as time "h:mm"

[davedave24]

    textTime = Format(textTime, "h:mm")

This code in the _exit event of the textbox makes the textbox display 0:00. How do I correctly format the user's input to time, so they can type in '1245', and the textbox converts it to '12:45'?

 

[SkipVought]

Hi,

The Format function converts Date/Time values, which are NUMBERS, to TEXT.

Your argument is already text!!! It wants a REAL TIME value!

You ought to have a textbox for hours and a textbox for minutes, because you have no controil over what the users will enter. With two textboxes, you can at least test for NUMBERS within limits.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[davedave24]

Interesting. Thanks