You can't reference a form control without telling Access the name of the parent object (the name of the form it's on).
Try (Me.[MyhyperlinkField])
When the referenced control IS on the same form as the running code, you can use the short form on the object syntax by using the keyword Me.
When the referenced control is NOT on the form that the code is running from, the complete object reference is required:
Forms!frmMyFormName.myControlName ,where obviously you provide the correct object names - not the pseudo names I've used.
If you are sure that simply clicking in the field is sufficient (i.e. you will never want to edit the value shown) then np. Otherwise, I usually use the double click event to avoid firing such code when the user clicks into the control.
Last edited by Micron; 08-14-2017 at 06:04 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.