Date stamp

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

Hello,
I'd like a field for date stamp to indicate when a record
was first entered into a table.

Thank you in advance,
Ellen
 
In your table's design view, click on your DateStamp field. Then, look in
the lower left corner of the screen for the Properties. Go to the Default
Value property and enter the following: Date()

Save and close your table and you should be "good to go".
 
Thanks, Cheryl!
-----Original Message-----
In your table's design view, click on your DateStamp field. Then, look in
the lower left corner of the screen for the Properties. Go to the Default
Value property and enter the following: Date()

Save and close your table and you should be "good to go".

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.
 
Back
Top