convert text into a clickable link

  • Thread starter Thread starter Milton Snider
  • Start date Start date
M

Milton Snider

I would like to be able to convert URL text like http://google.com into an
active url. The text is in a memo field of a table. The text is updated in
the table via cut and past from word or word perfect. The memo field is
viewed on an html page along with other fields via asp. I would like to be
able grab any text after the html:// and before the next space and convert
it into a url. I am not sure if I should do this in access or in vbscript as
the data comes out.
Any ideas?
thanks
Milton

Version: Access 2002
 
I can't use a hyperlink field because the entire memo field is not a url,
just some text out of large paragraphs.
 
The hyperlink is inside a large paragraph. It will only be displayed with
the entire paragraph.
 
Back
Top