J jb2606 New member Local time Today, 18:51 Joined Feb 28, 2006 Messages 9 Feb 28, 2006 #1 Imagine a form where you have to input time value, example 15:30 or 02:00 etc... Is there a simple way to input 1530 or 0200 and access converts the value into proper time? The reason is to eliminate using the ":" each time.
Imagine a form where you have to input time value, example 15:30 or 02:00 etc... Is there a simple way to input 1530 or 0200 and access converts the value into proper time? The reason is to eliminate using the ":" each time.
pbaldy Wino Moderator Staff member Local time Today, 09:51 Joined Aug 30, 2003 Messages 36,157 Feb 28, 2006 #2 Try an input mask of: 00:00;0;_ and a format of short time.
J jb2606 New member Local time Today, 18:51 Joined Feb 28, 2006 Messages 9 Mar 1, 2006 #3 Ell Done. It Worked fine Thanks