Insert Now(0) with OnClick into a Text Box

[karmadog]

I'd like to click into a text box and have the current Date/Time inserted into the text box. Can someone tell me the code for that?

[keiath]

you can use this =Date() and this will show the current date in the text box

[karmadog]

Thanks Keiath.

I get a syntax error, so I need the complete syntax.....

Private Sub Comments_Click()
=Date()
End Sub

[ItsMe]

me.TextboxName.Value = Now

[karmadog]

Thanks ItsMe...that's what I was looking for.

Now I just need to make it stop inserting the date/time after the first OnClick so I can write some text!

[karmadog]

Never mind... I changed to OnFocus and it works like it should.

[ItsMe]

Cool, don't think I would have thought of that.