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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I convert text field to memo field in a query 10
how can I specify text criteria when querying a memo field 1
#error - Blank 3
Convert and sort date originally formated as text 3
Convert Query field display from text to hyperlink 3
Numeric Field Overflow when appending date - how to convert it to text 1
Convert a memeo field to a text field 6
Memo fields in a query 4

Top