Can a query field display as datatype hyperlink?

  • Thread starter Thread starter r.f.miller
  • Start date Start date
R

r.f.miller

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

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