How to auto populate date/time

T

tschwinn

Building a form. I would like to double-click on a box and it auto populate
the time. I put =Time() in the Double-Click event but that did not work. Also
tried Now(). Any ideas on how to get this to work?
 
A

Arvin Meyer

tschwinn said:
Building a form. I would like to double-click on a box and it auto populate
the time. I put =Time() in the Double-Click event but that did not work. Also
tried Now(). Any ideas on how to get this to work?
Click to expand...

Try it in code:

Private Sub txtWhatever_DblClick(Cancel As Integer)
Me.txtWhatever = Time()
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top