EMail Address Field

  • Thread starter Thread starter Roger Bell
  • Start date Start date
R

Roger Bell

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
 
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.
 
Back
Top