complicated append

[ellenr]

This may not be the proper forum, but I don't know where else to put the question. Table1 is a mysql table with a memo field which is set up in a form as a rich text field. I can copy and paste lines from an email and they display properly. Viewing that field in the underlying table they have <br />, etc.

Table2 is another mysql table, containing a memo field in plain text. I need to append the records in table2 to table1. The memo field gets appended as one long run-on sentence with no LF/Cr or <br />. How can I programatically convert the plain text to rich text either before, during or after the append?

 

[nathansav]

Are you doing the append in access? There is a plaintext() function in Access i believe.

 

[ellenr]

Yes, I am using Access. I want the opposite of plaintext() -- I want to go from plain text to rich text. I have just tried: Replace([memofield],Chr(13) & Chr(10),"<br />") and it seems to work on my test data. Does anyone see any problems with this?