I currently have an Access backend with some fields defined as Hyperlink. This lets me click on the field from an Access form to open the web site, email address, pdf file, etc. I plan to move the backend to a 2008 R2 SQL Server where "Hyperlink" isn't a valid data type. After I do that, how do I edit the field (Access provides a right-click, Hyperlink, Edit method) and how do I just click on it to open the file.
Thanks, Eddie