Share via

Union Queries Expanding Hyperlink Fields

Anonymous
2012-01-19T02:46:09+00:00

All,

I have a problem with a Union query in MS Access 2010. The inputs to the Union query have a hyperlink field with a web address. In every query that leads up to the Union query, the hyperlink field is displayed as a hyperlink. After the Union query, the resulting field is replaced thusly:

For example, if the hyperlink field contains www.****, the resulting field in the Union query is www.****#http://www.****#. What do I need to do so that the field stays a hyperlink field without addition of the web address with a delimited full URL address.

Thanks, in advance,

Ray

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-01-19T03:03:09+00:00

Oops! I found the answer. I just set the Is Hyperlink property in the field in the report to Yes, and the Display As Hyperlink property to Always.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest