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

input mask on form for time-to show am and pm

P: 107
When I use input mask on form for user to enter time( medium time format)
Is there a way to fill in am and pm - so they don't have to input that?
Thank you
Jul 29 '08 #1
Share this Question
Share on Google+
4 Replies

Expert 5K+
P: 8,638
What I usually do in these cases is use a combination of the Input Mask and Format Properties:
  1. Input Mask ==> 09:00;0;_
  2. Format Property ==> hh:nn AM/PM
  3. Sample Output:
    • 1100 ==> 11:00 AM
    • 2300 ==> 11:00 PM
    • 0100 ==> 1:00 AM
    • 1300 ==> 1:00 PM
  4. This system works quite well, if you don't mind entering certain vales in the Military Time Format.
Jul 29 '08 #2

P: 107
I will try this and get back here
Jul 29 '08 #3

P: 107
noticed I never replied.
Thank you
it works- but want to input regular time not military
Aug 6 '08 #4

Expert 2.5K+
P: 3,532
If your users can't enter times in military fashion, they'll have to take the time to designate am/pm. Access is good, but it can't intuit the user's intent. Aside from actually entering am/pm, the only other thing I can think of would be having as Option Group with two radio buttons. You could then put the time and am or pm together and store it.

Linq ;0)>
Aug 6 '08 #5

Post your reply

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