Carriage Return Problem In Text Area Control

[jmccolley]

I am using a text area dtc. When I type into the text area and press "Enter" the cursor moves to a new line but when the text is saved to the SQL 7 database and the text the carriage return is not saved. When I read the data back in to print in a report the carriage returns are lost. Is there a way to save carriage returns to SQL? Is this a question better left for the SQL forum?

Thanks!

 

[cbokowski]

you could replace carriage return with char(13) + char(10)

see sql books on line

mkMSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acdata.chm::/ac_8_con_03_7mch.htm