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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:
You set the textbox's property IsLink to True and its property ControlSource  to:

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

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Gustav BrockCIOCommented:
Answer provided.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
hyperlinks

From novice to tech pro — start learning today.