hyperlink help needed for newbie

[sambucaman]

Hi all, and apologies in advance if this is a very bone question, but I have searched and cant find a solution.

I have a very simple form, in which the user adds supplier details (company, name, rep, website etc)

In the website entry box, is there a way to turn whatever address is entered into an actual link, so next time the form is viewed, the user can just click on it and be directed to the relevant website (which would be different for every record)
I have tried all manner of VBA but cant get anything working

Again, apologies if this is the simplest thing in the world! Stuff is only easy when you know it!

Thanks

 

[ghudson]

Did you try the FollowHyperlink method?

http://msdn.microsoft.com/en-us/library/aa221236(v=office.11).aspx