I am trying to dynamically insert a URL into a a href tag. Here's the tag:

<a href="<%=(rsListing.Fields.Item("Maplink").Value)% >" target="_blank"><%=(mapLinkText)%>

- The item "Maplink" is a memo field in the MS Access db
- The data is a URL in URLencoded format
- This will return a null value when the field is not empty
- I tryed to embed the whole <a href> tag into a different memo field (not just the URL) that was already outputting data (with the same settings as the Maplink field) and this worked.

If anyone is familier with this problem, please lend me your expertise. Thanks.

Using ASP, create a page to post the results to and look at it closely before sending it to the database. This ensures there isn't a coding problem. Also try forcing it as string "CSTR" and also make sure the databse is Updating the record through the correct SQL/asp statements.