Hyperlinks displaying hashes (#)

[grinder332518]

I have a query which accesses a table with 2 fields which are hyperlinks.
There is no problem with the display.
But if I then enhance this query with a union ,the hyperlinks now show "#" symbols
at the beginning & end of each hyperlink in the query.

Where do they come from, and how do I remove them ?

Many thanks

 

[HiTechCoach]

The # have always been there. The are required in a hyperlink data type to separate the parts. They are displayed with a specific format to show as a link.

My guess is that something in the union query is converting the data type to text which is removing the formating.

Note: This is another reason why I do NOT use the hyperlink data type.

 

[Simon_MT]

The hash symbol denotes a multi-value array or multi-part value, so it is a pain in the posterior it descriptors contain hashs.

As Hi-Tech coach said do'nt use the hypertext datatype. It's easy to construct a hyperlink including QueryStrings

Function Web_Books()
        Dim WebLink As String
        WebLink = GetWebPath & "Books.aspx?BA=1"
        Application.FollowHyperlink WebLink, , True
        HideWebToolBar
End Function

The GetWebPath signifies the web site.

Simon