Default Value =now() in table

  • Thread starter Thread starter Steve Stad
  • Start date Start date
S

Steve Stad

I have a Default Value of =now() for a DateEntered field formatted as General
Date. I noticed when I copy pasted a group of 4 records the DateEntered
field did not update automatically. Could it be because I copy/pasted a
block of records or can you tell me when/how it is supposed to update
automatically from w/in the table. The DateEntered works OK on the form but
the form add/enters one record typed at a time - is that the difference?
 
Realistically, copy-and-paste is seldom a good idea when working with
databases.

Default values only apply for new records, and you're allowed to overtype
the value before the record's saved. Since the records you're copying
presumably have the DateEntered field populated, Access takes that value,
since there's no need for a default value!

More appropriate than copy-and-paste is to run an Append query and specify
which fields should be appended (in addition to which rows)
 
Thanks Doug - You are exactly right. TimeStamp for date entered works
w/Append. Now - I see the blank value I was pasting in date entered
overtypes the default value =now().
 
Back
Top