Access - enter date automatically

  Yorkie 22:35 22 Jan 04
Locked

Can anyone help me to insert the date in a text field automatically when the text box is entered in a Microsft Access database.

  Sir Radfordin 23:59 22 Jan 04

If using a form you can use Now() as the default value which would work...I think!

Otherwise it may need to be done using VBA - give us a bit more info on what it is you are trying to do and I'm sure someone will be able to help.

  AccessMoron 17:38 23 Jan 04

if the text box is called Mytxt then in the GotFocus event
Mytxt.value = date

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5