Is there a way to insert a line break inside a ntext or varchar records. This suppose to be a log record field that each login is a new line in the same record.
I don't want to read the record first and then update it, I would like to perform this in single action.

Thanks.

Yes, treat it like a normal insert adding a vbCrLf as the line break.
I have a scenario like this inserting into a history table, this tracks who updates records (similar to your log field) this is a Text data type for scaleability. What I do:

'get your existing log/history field
sql = "SELECT history FROM events WHERE id=" & request.form("eId") & ";"
set getHistory = conn.execute(sql)
'append your line break and the new entry
newHistory = getHistory(0) & vbCrLf & newString
'update the field
sql = "UPDATE events SET history = '" & newHistory & "' WHERE id=" & request.form("eId") & ";"
conn.execute(sql)

Wind is your friend
Matt

Thanks.

I have found a nicer and elegant way to update the record and push it down one line:

    strSQL = "UPDATE table SET record = ISNULL('" & vbcrlf & "' + record,'')
    adoCon.Execute strSQL

Thanks for your help.

glad to hear. I must have misunderstood your post, I thought you wanted to append new entries to an existing record inserting a line break in between

BTW, this works?
" & vbcrlf & "' + record,''

I imagine you want to use a & inplace of the +

Wind is your friend
Matt