Formatting Hyperlink Field to Email

[Guest]

Is there a way to set my hyperlink field so that when an entry is made it is
always recognized as an e-mail entry? Currently, when data is entered into
this field from my form it's default is to recognize it as an http://
address. Right now we enter the e-mail address and then open the hyperlink,
change it to an e-mail address and enter the subject line.

I was checking around this discussion board and found a recommendation for
changing the field to 'text' and putting in an Event code, but I have no
experience with this. Would that erase or change the data that's already
stored? What kind of event code would be used?

Thanks for your help.

 

[Guest]

if you add mailto: in from of the email addresses it should resolve your
problem\

FYI from what I've hear this problem has been resolve in Access 2007.

Daniel