Time in Text Field

[JOE POLLOCK]

I need to have a bound text field in my form which, when that field is
clicked on the current time, in hours, minutes and seconds will appear. Any
suggestions?

 

[John Spencer MVP]

Use the click event of the field and add VBA code that sets the value to Time.

Private Sub txtShowDetails_Click()
Me.txtShowDetails = Time()
End Sub


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County