How can I create a functioning hyperlink on a form while displaying the sting value from another form field rather than the actual hyperlink's path? I'm working in Access 2003 and have a form sourced to a query which contains the hyperlink/path and other data elements for each record.
I've tried using the 'mouseover' event property with
Although my hyperlink address was in a table and being referenced by a query and subsequently by a form control, I realized that the display text of my hyperlink needed to be added to the address in the table rather than trying to concatenate the two hyperlink parts in a calculated form control.
My hyperlink now works and displays the text I needed.