Default time data to PM value

[JimO]

Want to enter start times for sports events. The vast majority start after 12:00 PM and I would like to have the starting times default to a PM not AM.



Currentyl set up as:

Data Type, Date/Time
Format, Medium Time
Input mask, 0:00 P

but times do not reflect as PM.

If I enter 0330 the value displayed is 3:30 AM, I want to show it as 3:30 P.

Thanks,
Jim O

[June7]

I am not seeing any way to force PM with InputMask. Even user typing "P" doesn't work.

Options:

1. Remove input mask and user types full time, including colon and "P".

2. use ShortTime format and enter 24-hr time. So 0330 would be entered as 1530.

3. UNBOUND textbox and VBA code saves value to field

[JimO]

So basically it is not part of the program. Something the powers that be might want to add (as a convenience).

IF that is the case I will mark this as solved.

Thanks
Jim O