>> Microsoft DTP format time

[Guest]

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

 

[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

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]

 

[Guest]

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]

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