mailto as Hyperlink defalt

[Ants]

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!

 

[BSJWright]

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

 

[ghudson]

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.txtEmail

If 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.

 

[kingdoby]

email question

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

 

[ghudson]

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

That is a first!!!

And you are welcome!