I have a text box which is used to store e-mail addresses. When the e-mail address is entered in Access sets the Hyperlink to http://. Is there any way of setting the hyperlink to defalt to "mailto:"? I always have to go into edit hyperlink and change the setting myself.

Shall look forward to any comments and advices!

I too would be interested to know if this is possible. Has anyone got any ideas?

I suggest that you store the email addresses in a table field that is formatted as TEXT. Then you can use the OnClick event of the text box or place a small email button besides the text box to wrap the MailTo function with the value of the text field. This example uses a text box named txtEmail...

Application.FollowHyperlink "mailto:" & Me.txtEmailIf you had searched the forum for the keyword MAILTO then you would have found a ton of threads to point you in the right direction.

I wanted to publicly apoligize for being rude, I was getting frustrated. Your solution worked fine. Thank you again

I wanted to publicly apoligize for being rude, I was getting frustrated. Your solution worked fine. Thank you againThat is a first!!!

And you are welcome! :)