Medium Time Format

[Numpty]

The Format of medium time is 00:00 PM.

Is there anyway of formatting this futher?

I have a field on a report which shows times of courses booked and is sent to customers. Presently it will display a course time as

09:00 AM - 04:00 PM

I would prefer if it could be 9:00 AM - 4:00 PM as showing a PM time as 0400 is not really correct.

 

[pdx_man]

Check out User-Defined Date/Time Formats under Access Help.

Using the Format statement:

"h:mm AM/PM"