I'm importing data scraped from an old web based database and placing the contents into MS Access. The old database has text fields with crlf's and blank lines but when I write this data into Access it all disappears. If I write the same data to a VB message box the crlf's are maintained so I guess something to do with the Access field (I've tried plain and rich text but no difference):
So I went back to basics and simply wrote the following string to the database but still got the same result:
So it seems it could be an access field/text box format issue?
Has anyone got any code that successfully writes crlf's to an MS Access long text field formatted as "Rich Text" and displays correctly in a text box?
Code:
rsu!comment = (xmlNode.nodeTypedValue) 'Write content to database
MsgBox (xmlNode.nodeTypedValue) 'Debug msgbox
So I went back to basics and simply wrote the following string to the database but still got the same result:
Code:
teststr = "This is Line 1" & vbcrlf & "This is Line 2"
rsu!comment = teststr
MsgBox = (teststr)
So it seems it could be an access field/text box format issue?
Has anyone got any code that successfully writes crlf's to an MS Access long text field formatted as "Rich Text" and displays correctly in a text box?