Set Date Stamp

R

rocket

I want to set a date stamp for the date a record is created without the
field being changed everytime the record is accessed, how do I do this?

J
 
S

Steve Schapel

Rocket,

Set the Default Value property of the field in the design view of the
table to Date()

- Steve Schapel, Microsoft Access MVP
 
A

Allen Browne

1. Open the table in design view.

2. Add a Date/Time field to store the record creation date.

3. In the lower pane of table design, set the Default Value property to:
=Date()
Alternatively, if you want to store the time as wall as the date, use:
=Now()
 
Top