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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…