Field = Hyperlink vs email value

[DubboPete]

Hi all,

I have noticed that if one creates a hyperlink field, and tries to use that
for storing email addresses (aka (e-mail address removed)), that even A2K still
defaults to the [[email protected]#http://www.abc.com] and unsuccessfully
tries to open up an internet address when the corresponding field is clicked
on a form.

Does anyone know if this is set in stone, or is there a way that clicking
the field can support sending an email, or starting the default email
proggy?

Any code appreciated

TIA

DubboPete

 

[Allen Browne]

Pete, it's easiest to use a Text type field to store email addresses, not a
Hyperlink type field.

You can still send an email in the Click or DblClick event of the text box
that contains the email address, using the SendObject action (with
acSendNoObject.)

If you want more ways to handle emails from Access, Tony Toews has an entire
FAQ on it:
http://www.granite.ab.ca/access/email.htm