I'd love for someone to show me how I can transform a long text, plain text value into a clickable hyperlink in a report. The value that I'm storing works with the Application.FollowHyperlink, but now I want to export my reports with a clickable link.
So far, what I've found tells me that I need to convert the field to a hyperlink value. Since some of the sites I'm storing are longer than 255 characters (https://stackoverflow.com/questions/16424917/long-url-in-sharepoint-for-url-type-field), I don't think that's an option.
I tried the below hoping that it might work but it's only displaying #Type! for every entry.
The solution will have to handle SharePoint links, local computer paths and websites.
So far, what I've found tells me that I need to convert the field to a hyperlink value. Since some of the sites I'm storing are longer than 255 characters (https://stackoverflow.com/questions/16424917/long-url-in-sharepoint-for-url-type-field), I don't think that's an option.
Issues with the Hyperlink data type in Microsoft Access
Description of and solutions to the issues with the Hyperlink data type in Microsoft Access. The article includes working VBA sample code.
codekabinett.com
URL - Clickable Report Field
Hello, I have searched through the forum and cannot find an answer to this question, or in some cases I may not understand properly what is meant. Please help. I have a table with Courses entitled COURSELIST. One of the fields is the Course Title, and one field is the URL where the course is...
www.accessforums.net
Microsoft Access tips: Introduction to Hyperlink fields
How to use the Hyperlink field type in a Microsoft Access database, with examples.
www.allenbrowne.com
I tried the below hoping that it might work but it's only displaying #Type! for every entry.
Code:
="#" & [Website_SharePoint_Site] & "#"The solution will have to handle SharePoint links, local computer paths and websites.
Last edited:
