Create a Hyperlink in a Query from text fields

  • Thread starter Thread starter Kurt Grimm via AccessMonster.com
  • Start date Start date
K

Kurt Grimm via AccessMonster.com

I would like to create a hyperlink, using just a query, by concatenating
different text values from multiple columns. I do not want to use a form,
report, or VBA coding. I can do the concatenantion, but the result set
shows as text. How do I make that a hyperlink in the result set?

Thanks...
 
Howabout you make a blank text field first. Then run your query as an
update query, filling that blank field with what you want.

Once you have it populated, you might be able to go into table design view
and change the field data type from "text" to "hyperlink."

I've never done this particular thing, but it seems like it might be an
option.
 
You must log in or register to reply here.

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

Can a query field display as datatype hyperlink? 1
Access 2007: Need more info on 'concatenante fields' 1
Convert Query field display from text to hyperlink 3
Return Hyperlink from Query on Text Field 1
MS Access: Creating hyperlink field in a query 0
Hyperlink Part 1
update hyperlink values but not displayed text 1
create hyperlink & append table 1

Back
Top