Access 2007 Add notation to memo field in multiple records (1 Viewer)

What I'd like to be able to do is filter by form in a contact database and simply add a carriage return, timestamp and comment to the top of a memo field for each of the records selected.

I've tried a simple search-and-replace as well as a simple update query but in both cases the carriage return/line feed codes are placed literally rather than causing an actual carriage return.

The other problem with this approach is that there may be times when I don't have anything to search for and therefore replace in the memo field.

I'm guessing VBA is the right way to go. I have no idea how to code something like that. I'm sure this question has come up numerous times but can't really find the answer in part I suppose because I am using the wrong search criteria since I don't really have the lingo down either.

Can anyone post a link that would get me started on this? Or a surefire search phrase? Thanks.

Welcome to the forum.

The following code should do what you want;

This will add a carriage return followed by the time/date stamp, your comment to the note in the current record and all subsequent records, in the form.

SOLVED

That's brilliant John Big Booty: I made a couple of tweaks, adding in a more human-readable date stamp and an input box for versatility then attached it to a button as here:

Thanks so much. I've been looking for this solution for a few weeks now. :banghead: