Create URL Links in Textarea

T

travelerkgd

Yes, I was wondering if anyone knew how to create a working URL in a textarea
of MS Access. Thanks!
 
J

John Nurick

Assuming you mean a standard Access textbox on a form, you'd need to
write code that responds to a click or double-click by examining the
text around the position of the insertion point to see if it looks like
a URL; if so, pass it to Application.FollowHyperlink.

(On second thoughts, it would be simpler to use a regular expression to
find any substrings that look like URLs and then check whether any of
them span the insertion point.)

But you wouldn't be able to colour or underline the links because the
textbox doesn't allow any differentiation in formatting.

A rich text control could do that. It's possible that some rich text
controls can automatically detect and highlight URLs : if the budget
allows I'd check out Total Access Memo from www.fmsinc.com.
 

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

Top