Microsoft DTP format time

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

On Wed, 15 Nov 2006 13:56:02 -0800, Jonathan
wrote:

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]

"John Vinson" wrote:

On Wed, 15 Nov 2006 13:56:02 -0800, Jonathan
wrote:

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]


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