How do I get the current time to pop up in a field by double clicking?

S

Shane

I am trying to design a form with a field that will
simply allow me to double click for the current time but
I can't figure it out. I input =Time() in the Events tab
for On Dbl Clk but it doesn't work. HELP
 
R

Roger Kehn

-----Original Message-----
I am trying to design a form with a field that will
simply allow me to double click for the current time but
I can't figure it out. I input =Time() in the Events tab
for On Dbl Clk but it doesn't work. HELP
.

Instead of putting "=Time()" on the doulble click event you
need to select create "Event Procudure" and have to code
look like this (note - "Text0" is the name of my example
field):


Private Sub Text0_DblClick(Cancel As Integer)
Me.Text0.Value = Time()
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top