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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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

Run Make Table Query on Union Query 2
How do I return display portion of hyperlink in union query 1
Union query 5
Union Query to list duplicates 2
Union Query and Field Alias 7
Union Query 2
UNION question 3
Union Query 2

Back
Top