sql server - Detecting split character in string -

recently had problem splitting html string separate columns in access 2010 , store date in sql server 2008r2 table. works more or less because number of lines varies.

to avoid storing html-tags have easier solution, use text field in access formated standard while other text-field formated rich-text contain format.

inserting same content, copied html mail in standard text field maintains line feed !

how can "detect" character replace character further use??

example:

<div><font face=arial size=3 color=black>customer name</font></div> <div><font face=arial size=3 color=black>customer address</font></div> <div><font face=arial size=3 color=black>12345 city</font></div> 

is copied content html mail , inserted rich-text field.

if copy content standard text field looks this:

customer name customer address 12345 city 

in server table content of field looks this

customer name  customer address  12345 city 

but maintain line feed in access field there must character, which??

thanks! michael

in sql-server table, multiple rows shown 1 row. if set controlsource property of access textbox column, shown multiple lines.

if still want know characters: it's combination of ascii control characters cr , lf (chr(13) & chr(10) or vbcrlf or vbnewline). in sql-server syntax it's char(13)+char(10).