Append a new comment to an existing comments in a memo field using VBA (Access 2007)
Posted on 2011-02-18
Hello, I would like to programmatically (VBA) append a new comment to a memo field that already has comments in it. The desired result should be to create a new line for the new comment.
This is how this will look like in the memo field:
This is the first comment.
This is the second Comment.
This is the third comment.
And NOT: This is the first comment. This is the second Comment. This si the third comment.
I need to use the hard return for each new comment
I am currently using:
Me.Notes = Me.Notes & vbCrLf & "Kit mailed e-mail sent by " & Forms![Welcome]![UserName] & " on " & Date & "."
However, this does not give me hard return between the existing memo and the new appended note. I have also tried Chr(13) & Chr(10) instead of vbCrLf and I am getting the same result.