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 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

[Stewart Ross]

Hi grinder. The '#' symbols are internal delimiters within the hyperlink, as a hyperlink actually has multiple components of which the display text is just one part (the bit the user sees). Underneath it and unseen by the user in most cases is the hyperlink address or sub-address (which is the redirect used when the hyperlink is activated).

I suspect (though I have not tested this out) that you are seeing the delimiters because of type conversion taking place in the UNION query, especially if you are unioning a text-based field from another table in the same position as your hyperlink field. Otherwise how could the multi-layer hyperlink be carried forward in the UNION with another type?

If I'm right that this relates to type conversion issues I'd suggest finding an alternative approach in place of using the UNION query if at all possible.

-Stewart

[grinder332518]

Hi Stewart.
I did find an alternative approach :
From the Form which accesses the Query :-
I went into Query View,
right clicked on each field, &
set 'Is Hyperlink' from the Format tab to 'Yes'.
The displays then ignore the hashes, & the links are displayed as intended.

Many thanks for your contribution.