convert text into a clickable link

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
 
M

Milton Snider

I can't use a hyperlink field because the entire memo field is not a url,
just some text out of large paragraphs.
 
M

Milton Snider

The hyperlink is inside a large paragraph. It will only be displayed with
the entire paragraph.
 
Top