entering time without typing the colon

[swaybright]

Is there a way for users to enter a time into a date/time field without needing to type the colon?

Specifically, users should input time in military format but if they forget to put a zero in front of times earlier than 10:00, I would like the field to correct and accept the value.

Typed[tab][tab]Value
0230[tab][tab]2:30
230[tab][tab]2:30
1330[tab][tab]13:30

I attempted the following input mask !90:00 however, if the user does not type the zero, it does not seem to fill from right to left and gives an error that value is not appropriate for the input mask (Example 2 from above)

 

[SkipVought]

On your form you ought to have a control for Hours and one for Minutes and edit the entries appropriately.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[1DMF]

have you tried any input masks?

http://bytes.com/topic/access/answers/655006-input-mask-military-time

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music