Hello. I have set some textboxes up to hold times that can either be manually entered by clicking in the textbox and entering the time or the time can be automatically entered by clicking on a label next to the textbox. Both the form textbox and the table field are set to short time with input masks of short time.
The problem is that if a time that was auto entered by clicking on a label (through vb code) is editied, Access changes the format of the time as soon as the textbox is clicked on to edit resulting in the need to delete the AM/PM designatior. This does not occur if editing a manually entered time. I used the following code in the operation:
Private Sub lblalsonscene_Click()
Me.Req_ALS_Onscene = Time
End Sub
How can I stop this from happening?
Thnks
The problem is that if a time that was auto entered by clicking on a label (through vb code) is editied, Access changes the format of the time as soon as the textbox is clicked on to edit resulting in the need to delete the AM/PM designatior. This does not occur if editing a manually entered time. I used the following code in the operation:
Private Sub lblalsonscene_Click()
Me.Req_ALS_Onscene = Time
End Sub
How can I stop this from happening?
Thnks