Line Break in SQL Value

We've built a page that allows users to enter items that will ultimately
become a list.  One particular user enters them into the textarea on the
page and for some reason always puts a hard return into the textarea before
she submits.  This goes into SQL as a line break and it's screwing up how
the page renders.

How do I find this via code so that I can replace it?  I've tried looking
for chr(13) + chr(10) and vbCr and vbCrLf and replacing them with "" but it
doesn't seem to work.  Am I missing something?

Thanks,
James

Hello!

chr(13) + Chr(10) is the same as vbCrLf.
Did you allready try vbLf?

regards
b.wurm


"James" <letyoudown@verizon.net> schrieb im Newsbeitrag
news:uQ8yxwpaFHA.2520@TK2MSFTNGP09.phx.gbl...
> We've built a page that allows users to enter items that will ultimately
> become a list.  One particular user enters them into the textarea on the
> page and for some reason always puts a hard return into the textarea
> before
> she submits.  This goes into SQL as a line break and it's screwing up how
> the page renders.
>
> How do I find this via code so that I can replace it?  I've tried looking
> for chr(13) + chr(10) and vbCr and vbCrLf and replacing them with "" but
> it
> doesn't seem to work.  Am I missing something?
>
> Thanks,
> James
>
>