Set Date Stamp

  • Thread starter Thread starter rocket
  • Start date Start date
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
 
Rocket,

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

- Steve Schapel, Microsoft Access MVP
 
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()
 
Back
Top