Creating an "History" field

[Stephenn]

I'd like to create an edit history. I have a db that has a field for "Response". I've created a "History" field to feed the "Response" text to. This field will accumulatively display past "Response" texts along with a date/time stamp for each "Response" entry. The script I've written will also delete the text in "Response" upon feeding it to "History".

Here's the problem I have: I can't seem to figure out how to generate two carriage returns after each "Reponses" entry in the "History" field. All the entries feed over creating one long paragraph in "History".
Ex:
1-1-02 4:12 PM text text text text.1-2-02 4:00 PM text text text text. 1-3-02 3:002 PM text text text text.1-4-02 2:15 PM text text text text.

I would like:
1-1-02 4:12 PM text text text text.
1-2-02 4:00 PM text text text text.
1-3-02 3:05 PM text text text text.
1-4-02 2:15 PM text text text text.

I'm a VB beginner and have been learning by trial and error as well as forums and literature, so I won't display the script I already have because I'm hoping someone will provide a complete script for what I'm trying to do.

Thanks in advance to all.

 

[DBL]

"Chr(13) & Chr(10) " together without quotes creates a new line but I'm not sure that's what you need. I think that you might need an audit trail that would put results to a separate table. Search the forum for audit trail. There is also an MSN article on the subject http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

HTH

 

[Stephenn]

Thanks, the article was very good. It wasn't what I was looking for at the time (the characters DBL gave me worked fine for what I wanted to do), but after reading the article and trying out the code, I see excellent uses for it. Thanks, again.
Stephen