Date Stamp

[ladybug via AccessMonster.com]

I have a field that is set to date. I understand =Date() will enter the date
when you open the form or table. How do I get it to stay the original date
when the form is opened? It keeps changing to the current date.

 

[benyod79 via AccessMonster.com]

Use the following to make each new record the date the record is added for
your field.

Default Value: =Date()

The date the record is added is set to today's date and will stay that way
unless changed.

 

[ladybug via AccessMonster.com]

I cannot tell with date since it is still today, but I tried the same with
=Time() in the Default for the field in the table. On the form I entered in
all my info and the stamp was 10:26. I closed the form and reopened the form
to that entry and the stamp said 10:27.

 

[Jerry Whittle]

What benyod79 said is correct. The default value will be added for new
records. However a default value should not change anything on old records.
Therefore I think something else is going on here.

Open up the table for that form. What does the data say for the date field
in the table? Close the table and open up the form to that record. Then close
the form and go back to the record in the table.

If it has changed, then there is code on the form that is changing the date
field. It could be that the designed purpose of the field was to see the last
time that record was changed or even viewed.

It's also possible that there is no matching field in the table. You could
just be looking at an unbound text box that has the value of Now() or Date().