By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,667 Members | 1,348 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,667 IT Pros & Developers. It's quick & easy.

Input mask military time

AccessIdiot
100+
P: 493
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?
May 30 '07 #1
Share this Question
Share on Google+
8 Replies

Denburt
Expert 100+
P: 1,356
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
May 30 '07 #2

AccessIdiot
100+
P: 493
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!
May 30 '07 #3

Denburt
Expert 100+
P: 1,356
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.
May 30 '07 #4

AccessIdiot
100+
P: 493
Oh I get it. These guys were insisting on tabbing capabilities so it shouldn't be a problem. Thanks again!
May 30 '07 #5

Denburt
Expert 100+
P: 1,356
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.
May 31 '07 #6

AccessIdiot
100+
P: 493
:) 1. 2. 3. 7. 9. 10.
lol, is this some kind of code?
May 31 '07 #7

Denburt
Expert 100+
P: 1,356
lol, is this some kind of code?
Just wanted to send a smile but you need at least ten characters on a post. :)
May 31 '07 #8

AccessIdiot
100+
P: 493
Ha! I had no idea. :-)
May 31 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.