>> Microsoft DTP format time

J

Jonathan

Hi, this is probably simple and yet I don't seem to get it...
Using the properties I select a custom format for time so the control
displays a 12 hour clock including am/pm. The thing is
h:mm displays 9:35
h:mm am/pm displays 9:35 a35/p35

Any ideas how to display 9:35 am

Many thanks
Jonathan
 
J

John Vinson

Hi, this is probably simple and yet I don't seem to get it...
Using the properties I select a custom format for time so the control
displays a 12 hour clock including am/pm. The thing is
h:mm displays 9:35
h:mm am/pm displays 9:35 a35/p35

Any ideas how to display 9:35 am

Many thanks
Jonathan
Click to expand...

The "m" format value displays either months or minutes ("n"
unambiguously displays minutes), depending on the context. To get am
or pm displayed, use a/p. A format property of

h:nn a/p

should work.

John W. Vinson[MVP]
 
J

Jonathan

John Vinson said:
The "m" format value displays either months or minutes ("n"
unambiguously displays minutes), depending on the context. To get am
or pm displayed, use a/p. A format property of

h:nn a/p

should work.

John W. Vinson[MVP]
Click to expand...

Hi John, I'm attempting this in Access 2003 and for this version at least
the suggested format does not seem to apply to the date picker object. the nn
a/p are treated as literals.

May be the method I use is not correct... I select custom format and then
insert h:nn a/p only into the box and then click apply.

Any other suggestions appreciated.

Many thanks
Jonathan
 
Top