MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Date

Posted by Teri Fields on September 14, 2001 8:46 AM

I'm trying to create a MS Access application. I need to write a macro that automatically puts today's date in a data entry box as an "onClick event". I don't know the code for today's date, I thought it was
=()today, but that doesn't work. I'm new to VB and currently lost.

Posted by Mark O'Brien on September 14, 2001 10:33 AM

In VB the code for today is just:


Posted by Ed on September 14, 2001 12:39 PM

Not sure about VB but in any cell it should read =TODAY()