Access - enter date automatically

  Yorkie 22:35 22 Jan 2004
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 2004

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 2004

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.

Elsewhere on IDG sites

iMac Pro review

Illustrator of witty, relatable Instagram comics Julia Bernhard touches on our humble moments

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?