How to create a hyperlink by VBA for Access2000?

I tried it in a query constructor by adding #www.somesite.com# to the text string, but I get a string again "text#www.somesite.com#" not a hyperlink like text