I've got a quite simple MS Access Database that consists of some metadata about a lot of documents along with a hyperlink area that links towards the document on our network drive.

However, after i make use of a SQL Place statement to populate the web link area, the worthiness I provide only becomes the display text, not the particular link.

How do i result in the value a practical hyperlink? I'd believe that the web link data type would really create hyperlinks.

I am using Access 2002 SP3.

I don't like hyperlink fields they're bothersome and hard to edit. It's much simpler to utilize a text or memo area and employ followhyperlink within the code for the form. That being stated, the format for any hyperlink is: