I have a list box that is linked to a field that is in Memo format. I want to append comments to the list box as they come in, the newest being on top. Here is the code and I put psuedo code where I would like to add a blank line between the new and old comments.

txtComments.Value = cmbRep.Value & " " & Date & " " & Time & " " & txtNewComment.Value _
& " (Blank Line) " & txtComments.Value

The end result would be something like this.

'
Kelly B 10/30/2006 1:33:00 PM Confirmed address info was sent correctly but now we have two provider records that are exactly the same. We should have one provider record with one or more address records.

TW 10/25/2006 11:30:23 AM Will resend with corrected info, should be two different addresses.

Kelly B 10/20/2006 3:33:00 PM Provider info received with two addresses but they are the same.
'

Is there a way to do this?

Thanks,
Scott

__________________
ScottP

Yes. I think you want "vbCrLf"

That is the vb reserved name for "Carriage Return, Line Feed" (remember typewriters?!)

So it looks like you are taking the current value, appending your new data, and then pushing the concatenated value back in, which is the way to go. So like this:

txtComments.Value = cmbRep.Value & " " & Date & " " & Time & " " & txtNewComment.Value _
& vbCrLf & vbCrLf & txtComments.Value

Did that work?


mmcdonal

Actually, now that I look at this, I am a big fan of putting your strings etc into variables, and then concatenating the variables. Sometimes Access and VBA have a problem with taking values in functions. So maybelike this:

sOldString = txtComments.Value
sNewString = cmbRep.Value & " " & Date & " " & Time & " " & txtNewComment.Value

Me.txtComments.Value = sNewString & vbCrLf & vbCrLf & sOldString

I might not have gotten that in the right order, but you get the idea.

HTH

mmcdonal

Thanks, I used what you put in your second email to separate the comments, works great.

Thanks again,

Scott