make "mailto" the defult type of hyperlink

[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?

 

[John Nurick]

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?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.