My Access Tips

My Access Tips for Custom Microsoft Access

My Tips

Links

Resources

Question:
How can the user automatically enter the date/time values by double clicking the field?

Answer:
Add code to the double click event of the textbox:

Code:

Private Sub YourField_DblClick(Cancel As Integer)
       Me.YourField = Now() ' Date & Time
       'Me.YourField = Date() 'Date Only
End Sub