I got this from Fred in a previous posting. It works well.
Display your table in a form
You do not need to use the hyperlink datatype to send an
email to the address. Use a regular Text DataType instead.
Code the Double-click event of the form control that shows
the field:
Application.FollowHyperlink "Mailto:" & [ControlName]
Making corrections to the text field is much easier than
editing a hyperlink field.
Jim
-----Original Message-----
Is there anything I can do within a table to make an
EmailDisplayName a hot link so that when I pull the info on
my list of people into a FrontPage 2003 database results
page the email address is a hot link--users can click on to
send email to the individual?