I am trying to create a hyperlink from my suppliers table so that on my form I can click the selected suppliers email and it will paste this in outlook.

In my table the text has changed to the default colour of blue for the hyperlink, however when I select the email add I get this error msg "cannot download the information you requested". Also the text in my form is not blue but I am getting the hand as the pointer.

So far what I have done is set the email field in my table to hyperlink - it was previously text when I typed the emails I dont know if this would have any affect. I also set the email field property on my form to is hyperlink - Yes.

It seems to be puttinh http in front of the email and it is opening the suppliers website from my table but from my form I just get the error msg.

Can anyone tell me why I am getting this error and how I should resolve it.

Thanks alot

Got it sorted myself!!!

[This message has been edited by Hayley Baxter (edited 12-14-2001).]

[This message has been edited by Hayley Baxter (edited 12-14-2001).]

Using Hyperlinks for Email in Access is the cause of many head aches. Try the SendObject instead. It is much more functional.

Here is a recent thread with some sample code:

Topic: email field (http://www.access-programmers.co.uk/ubb/Forum2/HTML/001222.html)



[This message has been edited by BukHix (edited 12-14-2001).]