hyperlink e-mail field

[McLean ~]

I built a new table with contact information including an
e-mail field. The e-mail field will not hyperlink. I ran
an update query to add the "mailto:" text but that didn't
help. How to I make these fields link.

I know how to make all NEW entry hyperlink, what about the
close to 1000 records already there?

McLean

 

[Allen Browne]

The hyperlink field contains 3 or 4 parts, separated by #.
Massage both the Display and the Address parts.
HyperLinkPart() can help sort them out.

More info on the structure of hyperlink fields:
http://allenbrowne.com/casu-09.html