MS access 2010+ report with hyperlink creation issues

trying to create an access report which is output as HTML which contains a list of dates and reports for the user can select from. The report is driven by a DB query which contains a field with the date, a field with the report title and a field which has a url to the report. I'm trying to create a hyperlink that displays the report title field as a link and uses the other field as the actual link address. Can't seem to put the 2 fields together.
jsgouldAsked:
Who is Participating?
 
Gustav BrockCIOCommented:
You set the textbox's property IsLink to True and its property ControlSource  to:

=[DisplayField] & "#" & [UrlField] & "#"

Open in new window

0
 
PatHartmanCommented:
The hyperlink is one of those abomination data types that require specialized SQL since there are actually two fields involved..  If you change the table to contain two columns instead of one, you will find them easier to use.  Plus should you ever have a need to upsize to SQL Server, you won't be thwarted by having a non-compatible data type.  I don't have the specific SQL you need since I don't use the Hyperlink data type but at least you now know what you are looking for if you elect to stick with the hyperlink data type.
0
 
jsgouldAuthor Commented:
Pat: not sure I understand ur comment, but I have 2 separate input fields. One field has the text I want to display and the other has the url to the actual report. All I want to do is is have a hyperlink field that displays the text from one field and uses the when the link is clicked.
0
 
PatHartmanCommented:
That's what the hyperlink data type does.  In your table, is there one field defined as hyperlink or two fields.  One to hold the path or URL to the file you want to open and the other to contain the display value?
0
 
Gustav BrockCIOCommented:
Answer provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.