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

M

Mollymaloo

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

Mollymaloo

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