Enter a hyperlink to an existing file or Web page by using the Insert Hyperlink button

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 Existing file or Web page under Link to.
   
   
5. In the Text to display box, type the display text for the hyperlink. If you leave the box blank, then Microsoft Access will use the hyperlink address as the display text.
   
   
6. Click ScreenTip, and then 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 will display the hyperlink address as the ScreenTip.
   
   
7. Specify the file or Web page you want to link to in one of these ways:
   • In the Type the file or Web page name box, type a path or a URL.
     
     
   • Under Or select from list, click Recent files, Browsed pages, or Inserted links. Then click an item in the list.
     
     
   • Click File to search for a file on your hard drive or network.
     
     
   • Click Web page to search for a page on the Internet or an intranet.
8. To go to a specific location in an HTML file or to an object in a Microsoft Access database (.mdb) or a Microsoft Access project (.adp), click Bookmark. Click the bookmark or object you want in the list, and then click OK.
   
   
9. Click OK in the Insert Hyperlink dialog box.

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