I have a working .asp search function on my intranet (.asp page desiged in dreamweaver) which is linked to an Access 2003 .mdb database via a DSN-less connection. One of the fields on a table used to display results from the access database is entered as a hyperlink - eg google.co.uk. I want that hyperlink to be displayed in the results field on my .asp results page.

My question is - If go to the results page say in Internet Explorer can I have the results field eg Google.co.uk or whatever it is to be displayed as a hyperlink - thus letting me click on the link and take me there?

Try This: (be sure to replace RecordsetName with the name of your recordset and FieldName with the name of the url field in your database table.) This is ASP | VBscript


<a href="<%=(RecordsetName.Fields.Item("FieldName".Value)%>" target="_blank"><%=(RecordsetName.Fields.Item("FieldName".Value)%></a>