Search results

Ah, then yes you will need to make it a text or memo field. Essentially what you're trying to do here is have Access treat the value in the control as just a string and control the hyperlink process yourself through VBA. The problem at the moment is that Access is assuming that a user seeing...

Just use Application.FollowHyperlink [control name].value in the double-click event if the control's value would typically be a URL. You may need to throw in some error handling as I can't remember off the top of my head how exceptions are handled if a URL isn't valid. If you want the value...

My solution to hyperlinking a field that needs to be edited by the user is to set the 'is hyperlink' property to no, and to put an event procedure into the control's double click event to go to the desired link. This means that a single click will allow the user to edit the field with no...