Email address field setup in table and form?

[Guest]

I'm using Access 2002.
I want to store customers' email addresses in the Customers table and have
them useable on the Orders form i.e. click to fire Exchange and send a
message.
I thought it would be a simple matter of setting the data format as
Hyperlink, but if I do this, Access thinks is is a http address and gets
confused and locks the record.

How do I format the email address field in the table? As a hyperlink, or
not? Anything else to configure?
And similarly on the form - as a hyperlink, yes/no? Anything else to set?

Onboard help is virtually silent on the subject but I'm sure somebody here
can help me.
Thanks
CW

 

[Guest]

Does this help?

http://groups.google.com/group/micr..._frm/thread/1522b44b20b489c9/27968ec53a0d721f


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks, Tom. Looks promising and I'll give it a go.
CW