Formatting military time into non-military time

[WithoutPause]

I'm trying to format time in short form without using military time as the AM/PM data is being stored in a separate field. The following code doesn't work. I get a run-time error of 13 and type mismatch. DateAdd won't work since the format of the returned data is in Long Time form.

Private Sub CTime_AfterUpdate()
If Hour([CTime]) > 12 Then
CTime = Format((Hour([CTime]) - 12) + ":" + Minute([CTime]), "Short Time")


End If
End Sub

[NTC]

ummmmm - I'm not sure if there is a disconnect or if I misunderstand your post. Time is time. It can be 'displayed' either military or traditional. No coding is needed. When in design view of the object being seen (typically form or report) option the text box control format to be either Medium Time or Short Time.

[June7]

This error is triggered because the + is trying to add. Can't add string ":", therefore datatype mismatch.

Use & for concatenation.

[WithoutPause]

This error is triggered because the + is trying to add. Can't add string ":", therefore datatype mismatch.

Use & for concatenation.

Thanks. I figured it was something simple.