EMail Address Field

I have inherited a Data Base that has a field for EMail Address. This is
currently a Text Field. I have changed the field to a Hyerlink field and
would like to update all the data (Email address) in this field so that when
clicked the Email program will load. Is there a way I can do this without
having to edit each record and type the = sign so it is recognised as Email?

Thanks for any help

Sir,

Something like this:

http://www.blueclaw-db.com/download/...ss_outlook.htm

?

HTH VR/Lost

I think that you'd be better served by leaving it as a text field.
Hyperlinks use far more bytes and are stored in a different area in the
database (i.e. not in the same table) and therefore can corrupt more easily.
A bit of code, which adds the "mailto:" tag to the beginning of the string
will allow you to treat it and use it as an email address. Further, by not
using it as a hyperlink you are able to both index and sort the text.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Roger Bell" wrote in message
...
I have inherited a Data Base that has a field for EMail Address. This is
currently a Text Field. I have changed the field to a Hyerlink field and
would like to update all the data (Email address) in this field so that
when
clicked the Email program will load. Is there a way I can do this without
having to edit each record and type the = sign so it is recognised as
Email?

Thanks for any help