Query to change Hyperlink text and email

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

Guest

Is it possible to create a query that changes the display text of a hyperling
and the actual hyperlink info such as mailto: or //http:?
If this is not possible, how can I change this in a bulk for approx. 1450
records?

Thanks for the help (the Dutch usergroup could not support me on this)

Ron
 
Hi Ron,

See VBA help (esp. on the HyperlinkPart method) for information on the
contents of hyperlink fields. Given a hyperlink field called [Hyper] you
can use expressions like these in an Access query to return the various
"parts":

CStr(Hyper) AS FullContents,
HyperlinkPart(Hyper, 0) AS DisplayedValue,
HyperlinkPart(Hyper, 1) AS DisplayText,
HyperlinkPart(Hyper, 2) AS Address,
HyperlinkPart(Hyper, 3) AS SubAddress,
HyperlinkPart(Hyper, 4) AS ScreenTip,
HyperlinkPart(Hyper, 5) AS FullAddress

So you can either use CStr() to return the full text, along with the
usual string-handling functions to manipulate it however you want; or
you can use HyperlinkPart to return the parts you want, manipulate them
and then reassemble the modfied contents.
 

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

Change text to email hyperlink 4
Open specific hyperlink (accept) automatically in email with outlook 0
mail merge 1
Sometimes Text data may be better than Hyperlinks 1
Hyperlink in query field 3
hyperlink field to send email 6
change all hyperlink values in table 3
Hyperlink in query? 2

Back
Top