how to enter date by double clicking

[DeanRowe]

Hi,
I'm using Access 2000.
I've used an access form before where the user can automatically enter the current time & date by double clicking on the empty entry box.

Can anyone tell me if there's a tutorial that can explain how to do this please?
Or offer any advice to do so?

Any help would be greatly appreciated!

Many thanks

Dean

 

[MicroE]

Add code to the double click event of the textbox:

Private Sub YourField_DblClick(Cancel As Integer)
Me.YourField = Now()
End Sub

 

[DeanRowe]

Thank you MicroE, entered the code and it works perfectly, thank you very much indeed!

 

[MicroE]

You are welcome.