Enter a hyperlink to an object in the current database in Form view or Datasheet view

1. Do one of the following:
   • In a Microsoft Access database (.mdb), open the table or query in Datasheet view.
     
     
   • In an Access database or Microsoft Access project (.adp), open the form in Datasheet or Form view.
2. Place the insertion point in the hyperlink field in the datasheet or in the text box or combo box that accepts hyperlinks on the form.
   
   
3. Click Insert Hyperlink on the toolbar.
   
   
4. In the Insert Hyperlink dialog box, click Object in this database under Link to.
   
   
5. In the Text to display box, type the text that you want displayed in the field or text box. If you leave the box blank, then Microsoft Access will use the object type and object name as the display text.
   
   
6. Click ScreenTip, and type the text that you want to appear when the pointer hovers over the hyperlink. If you leave the ScreenTip box blank, then Microsoft Access displays the object type and object name as the ScreenTip.
   
   
7. Select the database object that you want to link to from the list.
   
   
8. Click OK.

   Microsoft Access adds the hyperlink to the field or control. You can click the hyperlink to open the target object.