You need to replace any CR's with a <BR>

Try ...

sNewString = replace(sString, vbCRLF, "<br>")


-----Original Message-----
From: Sebastian Pittari [mailto:mailing@3...]
Sent: 02 June 2000 20:04
To: sql language
Subject: [sql_language] Carrier Return


Hi,

I am in the following situation:

-Text Field on a SQL Server 7 Table.
-Text inserted in that field by a form field throught an ASP page. Without
any restriction on lenght. Imagine that could be several paragraphs.

All right... Then

-ASP page querying that table for that field.
-Recordset feeded with that query.
-Value of that field asigned to a Variable.
-Variable embbeded in the HTML code.

I can't get the carrier return (ENTER) inserted in the original field form,
being presented in the HTML. I get an SPACE... If I insert three ENTERs,
then I get three SPACEs and never a carrier return.

How can I recognize a Carrier Return without any String Program Headhache?

Thanks in advance!

Sebs.