In Access, you can setup input masks. As the user enters data into a particular field, the data complies with the input mask. For example, if you setup an input mask as the following date format (10/29/00), the slash is automatically presented. My desire is to setup a textbox, which the user can use to enter a specific time for an alarm. When the time is entered, I would like for the ":" to automatically be present. This would allow the user to just simply enter the numeric time without having to insert the colons. So, the user would say enter 122200 and the textbox would look like 12:22:00 after the text is entered.

I have looked at the format function. And can't see how to integrate it like I would in Access(Microsoft Access).

Any help of course is greatly appreciated!

Sincerely,
Sal