467,140 Members | 1,381 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,140 developers. It's quick & easy.

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

100+
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
  • viewed: 3858
Share:
4 Replies
ADezii
Expert 8TB
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
100+
I will try this and get back here
Jul 29 '08 #3
100+
noticed I never replied.
Thank you
it works- but want to input regular time not military
Aug 6 '08 #4
missinglinq
Expert 2GB
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.

Similar topics

6 posts views Thread by dude | last post: by
1 post views Thread by John | last post: by
9 posts views Thread by msnews.microsoft.com | last post: by
5 posts views Thread by msnews.microsoft.com | last post: by
reply views Thread by gibsonsgman@gmail.com | last post: by
2 posts views Thread by =?Utf-8?B?RG9u?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.