Input mask military time

[AccessIdiot]

Argh! This is driving me crazy. My db users want to be able to enter a string of numbers for hours, minutes, seconds, in military time format (021256 for 2:12:56 a.m. and 152416 for 3:24:16 p.m.). They don't want to have to specify am or pm and don't want to have to type colons. I can't seem to create this input mask myself for some reason and the one that comes with Access doesn't have seconds.

Help?

[Denburt]

Look at the form report or query properties go to format and enter the following:

h:nn:ss

Then in the input mask you can enter:

00:00:00


As long as the database is set up to select everything in the field when going from a field to the next then you should be O.K.

They can type in:

122345

and it will appear as

12:23:45

[AccessIdiot]

Thanks so much! I had hh:nn:ss and it wasn't working. I never would have thought of the single h.

Can you clarify this though? I don't get what you mean:

As long as the database is set up to select everything in the field when going from a field to the next then you should be O.K.

Thanks Denburt!

[Denburt]

Well when I used the mouse to enter the field is seemed a little quirky. I think it was due to the mouse pointed it in the wrong position for the input mask. When I tab from field to field it was no problem.

[AccessIdiot]

Oh I get it. These guys were insisting on tabbing capabilities so it shouldn't be a problem. Thanks again!

[Denburt]

Oh I get it. These guys were insisting on tabbing capabilities so it shouldn't be a problem. Thanks again!

:) 1. 2. 3. 7. 9. 10.

[AccessIdiot]

:) 1. 2. 3. 7. 9. 10.

lol, is this some kind of code?

[Denburt]

lol, is this some kind of code?

Just wanted to send a smile but you need at least ten characters on a post. :)

[AccessIdiot]

Ha! I had no idea. :-)