>>>>Well, the value (or ControlSource) is an Integer. The format and mask just display it with the colon in between
>>>>So, if you want an hour you would enter 100. For one second enter 1
>>>>
>>>>How would the textbox know that 1 is either one second or one hour ?
>>>
>>>I'm not sure, but in my opinion it's inconvenient. I'd rather try with the classes Marcia suggested if I can get ahold of the article...
>>
>>Ok, sorry for the inconvenience
--------------
>Gregory,
>
>No problem, sorry for being so picky :) Anyway, I'm going to get classes from the book soon, so I may adapt them instead.
>
>The idea of this texbox basically works and it may work for my users too...
>
>Anyway, I'll play with other classes too and compare.
>
>Thanks again for your great input.
--------------------
Nadya,

You're welcome

What I wanted to say is that this is a rather quick way to enter one hour = 4 keystrokes: 1 0 0 ENTER

Should you have two textboxes, you would enter 3 keystrokes : 1 ENTER ENTER

In case of working with spinners (1) manual: 3 keystrokes, (2) with the mouse takes more time

1:15
with one textbox = 4 keystrokes: 1 1 5 ENTER
with 2 textboxes = 5 keystrokes: 1 ENTER 1 5 ENTER


Using two controls makes it more difficult to store hhmm in one table field

So, I find one textbox better. On occasions you'll have a keystroke too many

In the supermarket (cash register) they never enter the decimal point.
One dollar is 1 0 0 (or 1 00)
$1.50 is 1 5 0

In this case you never enter the colon, but you have to explain to the textbox where the colon should be - like the cash register - you never enter the colon [ or with two textboxes an ENTER or TAB ] and on occasions you have to enter a zero too many. But hey, you never enter the colon [ or decimal point ]