Type a hyperlink in a field or text box

1. Open the table, query, or form in Datasheet view, the form in Form view, or the data access page in Page view.
   
   
2. Place the insertion point in the hyperlink field in the datasheet or in the text box or other control that accepts hyperlinks on the form or data access page.
   
   
3. Type a valid hyperlink address. A hyperlink address can have up to four parts separated by the number sign (#):

   displaytext#address#subaddress#screentip

   The following example includes displaytext, address, and screentip. Note that it also includes the # for subaddress, which has been omitted:

   Microsoft Corporation#http://example.microsoft.com/##Example page for Microsoft Corporation

For more information on hyperlink addresses, click .

Microsoft Access adds the hyperlink to the field or control.

Notes  

• In a Microsoft Access database (.mdb), you can open the target document or Web page by clicking the hyperlink in a table, query, or form in Datasheet view or a form in Form view.
  
  
• In a Microsoft Access project (.adp), you can open the target document or Web page by clicking the hyperlink in a form in Form view or Datasheet view. In Datasheet view of a table, query, or stored procedure, the hyperlink address is displayed as a text string, not as a formatted hyperlink.
  
  
• In a data access page, the text box in which you enter a hyperlink address displays the hyperlink address as a text string, not as a formatted hyperlink. Look for the address formatted as hyperlink elsewhere on the page.

  The ScreenTip displayed for a hyperlink on a data access page is defined for the hyperlink control, so a ScreenTip that you enter won’t be displayed on the page.

  Click the Refresh button on the Microsoft Internet Explorer toolbar to see the hyperlink address displayed as a formatted hyperlink on the data access page.