Auto Date in Table/Form

[BartonTony]

Greetings to all the Wizzards out there...

Please can someone tell me how to configure Access 2007 to automatically enter a Date into a Field in a Table/Form with the option of turning off editing.

Many thanks...

Tony.

 

[JANR]

Set the DeafultValue of the date field to:

=Date() If you want the current date for every NEW records

or

=Now() if you want date and time for the record.

nb it will atomatically insert the value only for new records, old records have to be entered manually

JR

 

[BartonTony]

Thank you very much, this has been gratefully received.