Line Break in SQL Value

[James]

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

[b.Wurm]

Hello!

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

regards
b.wurm
"James" <le********@verizon.net> schrieb im Newsbeitrag
news:uQ**************@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