time format

[Oliver]

How do I format time to show 01:15 PM instead of 1:15 PM?
I need to add 0 for hours 1 - 9.

Thanks

Oliver

 

[Art]

Hi Oliver,
use an input mask for Medium Time.

Hope This Helps

 

[Guest]

I've tried that.I get times in my combo box in this format
1:00:00 AM
1:15:00 AM
..
..
..
If I enter the input mask 09:00\ >LL;0;_ I get error
msg "the value you entered isn't appropiate....."

Thanks

Oliver

 

[Elwin]

=Format([MyDatefield],"hh:nn AM/PM")

or just place the format in the format property of control

hh:nn AM/PM