make "mailto" the defult type of hyperlink

  • Thread starter Thread starter amanda
  • Start date Start date
A

amanda

hi. i have a hyperlink column in a table. it's full of e-
mail addresses. unfortunately, it appears that the
default, each time i enter a new address, is for the
hyperlink to look up a url based on the domain of the e-
mail address i've entered rather than launching my e-mail
client and addressing a message to the person indicated.
yes, i have discovered that i can fix this, one record at
a time, by editing the hyperlink to
read "mailto:[email protected]" rather
than "http://[email protected]," but it would be nice if i could
just change the default so that all hyperlinks in the
column are understood to be e-mail addresses instead of
urls. surely that can be done. anyone know how?
 
Hi Amanda,

AFAIK this isn't possible. It looks as if Access is hard coded to
prepend the http:// protocol unless another valid one (such as mailto:)
is present.

Instead, you can store the addresses in a text field. In a button, or
the click or double-click event of a textbox (I've called it txtEmail)
bound to the field, do something like this untested air code:

If Len(Nz(Me.txtEmail.Value,"")) > 0 Then
FollowHyperlink "mailto:" & Me.txtEmail.Value
End If


hi. i have a hyperlink column in a table. it's full of e-
mail addresses. unfortunately, it appears that the
default, each time i enter a new address, is for the
hyperlink to look up a url based on the domain of the e-
mail address i've entered rather than launching my e-mail
client and addressing a message to the person indicated.
yes, i have discovered that i can fix this, one record at
a time, by editing the hyperlink to
read "mailto:[email protected]" rather
than "http://[email protected]," but it would be nice if i could
just change the default so that all hyperlinks in the
column are understood to be e-mail addresses instead of
urls. surely that can be done. anyone know how?
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top