Converted from 2007 to 2000, DLookup for hyperlinks is seeing double.

[mhagerman]

These forums have helped me out in quite a few spots before, but this is the first I just can't figure out!

First: I have a database written originally in Access 2007 that I have downconverted to Access 2000. The DB has to run on this version. Everything was okey-dokey in 2007, but in 2000, one of my fields is behaving strangely. The field uses DLookup to read a value from a query and reports it as a hyperlink (which it is). However, in Access 2000, it always displays the hyperlink twice in the same field, effectively rendering the link useless. It does report the correct value, and is otherwise fine, except for the double reporting.



I've tested the DLookup function on the same form, and it works for other data types - just not the hyperlink. It also seems that when I change the text box that reports the hyperlink to a list or combo box, it only displays once, but these can't be clicked on and are equally as ineffectual. I've scoured the Properties of the text box as well as the query and can't figure out what's wrong.

Input and ideas are most appreciated. Since this is a work-related issue, I can't post the database, but if necessary I can copy the form/query to a new DB and provide that.

Thanks in advance,

Matt

[Dal Jeanis]

Are the # in the right places in the Access 2000 version text?

http://forums.devarticles.com/micros...inks-5483.html
http://office.microsoft.com/en-us/ac...005188821.aspx

[mhagerman]

Hi Dal Jeanis,

Thanks for your reply! It put me on a path to (eventually) figuring out the solution.

It turns out, Access was displaying the entire contents of the hyperlink data - meaning it showed the three parts of a hyperlink entry:

display text # file name # reference within the file

So I was "seeing double" because it was showing me both the display text and the file name, which in my case happened to be the same. After a lot of frustration with pound signs, I eventually resorted to using a label and converting it to a hyperlink using the following forum post:

http://www.pcreview.co.uk/forums/hyp...-t2314092.html

Specifically, using the me.lblName.HyperlinkAddress = "http://www.whatever.com" function and replacing the address with the DLookUp function I was currently using.

Matt

[Dal Jeanis]

Awesome! Pleaes mark thread "Solved". Top of page, under thread tools.