Set Field To Show As E-Mail Link 1

[jgarzoli]

Hi,

Using Access 2000

I have a form that displays data from a table. In the table is a field for email addresses. How can I set this field so that when users are seeing the address in the form, they can just click it and it will open their Outlook to email that person? I cant seem to figure out a way to make that address clickable, and have it open up their email client. Any ideas?

Thanks

J

 

[Remou]

You can use FollowHyperlink:

[tt]FollowHyperlink "mailto:" & Me.EmailAddress[/tt]

I find that the Double-Click event is best.

 

[jgarzoli]

Thanks Remou! Worked perfectly.