Create URL Links in Textarea

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Yes, I was wondering if anyone knew how to create a working URL in a textarea
of MS Access. Thanks!
 
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.
 
Back
Top