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

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.

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