I have a field with a medium time format. To save data entry clicks, i have an after update set to if the user entered the time in military format, that it would convert the time to medium time. This has been working great except for if a user enters 24:00, i get an error that says isn't a valid value. Why? It should just conver the 24:00 entered into 12:00 AM with my code. It converts 23:00 entered into 11:00 PM.
Private Sub txtFromTime1_AfterUpdate()
Me.txtFromTime1.Value = Format(Me.txtFromTime1, "Medium Time")