Access: Autofill date in table field

[gheyman]

If i default a date field to today (now()) does the new record always have that date in it or when i look at that record tomorrow does it change to tomorrows date? I dont want it to change.

 

[Joe4]

It should keep the date that the record was added and the default was applied.
The default value is just the value that gets applied when the record was added. It adds the actual value, not a formula. So it shouldn't change.