VBA today Date

[amfroehlich]

I have a feild which I would like to auto fill with today's Date. Can you tell me what the code to do this is.

Thanks,

Aaron

 

[Norie]

Set the default value of the field to =Now().

This will give both date and time.

If you only want the date try =Format(now(), "Short Date")

 

[bat17]

Or even =date()