Automatically enter todays date

[Oberion]

I'm a real newbie with Access. Can someone tell me, in nice simple terms, how to make Access automatically enter todays date into a field in a form?

 

[hermanlaksko]

=Date()

Rgds
Herman

 

[Lightning]

In Form Design view, open the property sheet for the control you want to set the date in.

In the control's Default Value property, type =Date()

This will enter the Date into the field whenever a new record is added.

If you want to add the Date AND the Time, use =Now()

See the following topics in the Access On-line Help file for more info.

About defining a default value that is automatically entered in a field or control
Set a default value for a field or control
Examples of default values in fields

HTH
Lightning

 

[flyboytim]

In the Table design view, for the date field, make the default value to Now(). Then in any form based on that table, or any new record added to the table in datasheet view, or append query that adds records, they all get the date and time the records were added to the table. The date and time allows you to see the order that the records were added. You can format the date field so that only the date shows.