Time and Date stamping

[Teri Miller]

Would any of you be able to help me with what is probably
an easy task for most of you?

I have a text box in a form that has the data type set
to "memo". I need this large an area because new
information may be added to this text box many times.

I need a way to time and date stamp each and every entry
into that text box and still be able to add more
information at a later date and have that entry time and
date stamped also.

Preferrably, once the entry is stamped, I don't want the
user to be able to change that entry or any before that.

I figure that if this process could be done once the text
box has lost focus, it would work out alright.

Is this too much to ask?

Thanks,
Teri

 

[David R. Eaton]

Based on what you want to do, I would suggest not using a single memo field
and instead create a subform linked to a different table with a date field
and a text field.
If you create a sepparate table with 4 fields (LogID, LinkField, date and
LogEntry) you can link the log table to the main table using whatever unique
identifiers tha main table has. When creating the sub-form, link the
"LinkField" (call it what you like) with the unique field from the main
database and you can have a running log with all but unlimited growth. Then
you can allow additions but not edits.

I hope this makes sense. I can visulaize it, but I am sure I am not relaying
it well.