Enter a hyperlink by dragging an Internet shortcut

1. In Microsoft Access, 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, or the data access page in Page view.
2. Navigate to an Internet shortcut (an icon on your desktop or an item in the History subfolder of your Windows folder).
   
   
3. Select the Internet shortcut.
   
   
4. Right-click the selection and drag the shortcut to the hyperlink field in the datasheet or to the text box or other control that accepts hyperlinks on the form or data access page.

   Microsoft Access adds the hyperlink to the field or control. On a form or datasheet, you can click the hyperlink to open the target document or Web page. On a data access page, the text box in which you enter a hyperlink address doesn’t format the address as a hyperlink. Look for the address formatted as hyperlink elsewhere on the page.

Tip   Click the Refresh button on the Internet Explorer toolbar to see the hyperlink address displayed as a formatted hyperlink.