Date of record creation

[Scott B]

Greetings,

Is there a way to record the date of a record's creation in a table that I
can see in a form? I do not want to be able to change the date once the
record is created. I want it to be there so I know when a record was
entered. It would only go away if the record were deleted.

Thanks,
Scott B

 

[Guest]

Greetings,

Is there a way to record the date of a record's creation in a table that I
can see in a form? I do not want to be able to change the date once the
record is created. I want it to be there so I know when a record was
entered. It would only go away if the record were deleted.

Thanks,
Scott B

Add a field to the table and set the default value to "Now()"
gm

 

[Tom Wickerath]

Hi Scott,

In addition to the advice offered by gm, you should set the locked property for the textbox on
your form to Yes. This will prevent any changes when the record is viewed using the form. Of
course, it won't protect from any changes if people have direct access to the tables or queries.

If you don't care about the time of day, use = Date()
as the default value instead of = Now()


Using the Date function will cause the default time to have a value of zero, which is the same as
midnight. This will not be displayed in the textbox (or in the table), unless you specifically
format it to display time.

Tom
________________________________________


Add a field to the table and set the default value to "Now()"
gm
________________________________________

Greetings,

Is there a way to record the date of a record's creation in a table that I
can see in a form? I do not want to be able to change the date once the
record is created. I want it to be there so I know when a record was
entered. It would only go away if the record were deleted.

Thanks,
Scott B