Can a query field display as datatype hyperlink?



Is it possible to display a field constructed from text concatenated from
other fields and have it displayed as datatype Hyperlink?
I want to create a query that builds a hyperlink in a field on the fly for
export that creates a static web page with these built hyperlinks. I could
build a new text field and then convert this field to hyperlink, but thought
there might be a more direct way to just define the query built field as
hyperlink. Thanks.



Allen Browne

Queries are not really meant to be the interface in Access. Create a form
(in datasheet view if you want it to look like a query.) You can then show
the calculated field as a hyperlink by setting the properties of the text

Be sure the include the 2 # characters in the field when you can concatenate
the values together.

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