UNION query hyperlink inactive. How do I make it active?

G

Guest

I have a UNION query that is pulling a variety of information from 2 tables.
One attribute in both tables is a hyperlink. Both tables have information
(hyperlinks) populated in the hyperlink field. When the UNION query is run
the hyperlink field is inactive. I need this to be active. How can this be
accomplished in the UNION query?
 
A

Allen Browne

Interesting. It looks like the UNION query fails to recognise it as a
hyperlink.

Could you create a form based on the UNION query?
Display in Datasheet view if you wish.
Set the IsHyperlink property of the text box to Yes.
 
G

Guest

That worked. Only problem is now I'll have to educate the user on how to
search using the filter buttons. They don't like change much. :)

Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union Query to list duplicates 2
Union Query 2
Union Query and Field Alias 7
How to assign table name to be value of a field in a UNION query? 2
Currency Format Lost in Union Query 1
Run Make Table Query on Union Query 2
How do I return display portion of hyperlink in union query 1
Union Query requesting parameter 12

Top