HTML <Href Link inside a form (HTML text box)

[Lingodude]

Hello, I am using a standard HTML Form to gather information from users and
one of the elements within the form is a text box that users will paste links
into, along with their plain text. The link could be anywhere within the text
box with text before and after it, etc. I take the text and put in into an
access db memo field. When I retreive the text, the text is truncated after
the '<' . Do I need to escape the <Href before I store the full text ?? I am
looking for a way to maintain the links as links once I query and reDisplay the
memo field content. I would rather not parse and test each chr in the field
before I right it to the db. Also, I don't have the option of adding an
additional URL field to the form. I see many examples on the web, including
CFMX based forums, but don't knmow what solution is used for managing
substrings within plain text. atm I am playing around with 'replace', but there
is probably a simpler and better way.

[BKBK]

You could replace < and > with < and > respectively before you send the text to the database.