By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Hyperlinks displaying hashes (#)

P: 28
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
Feb 16 '10 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 2,545
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.

Feb 17 '10 #2

P: 28
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.
Feb 17 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.