About hyperlink addresses

You can type a hyperlink address directly in a hyperlink field in a datasheet or in a text box or control that accepts hyperlinks on a form or data access page.

A hyperlink address can have up to four parts that are separated by the number sign (#):

displaytext#address#subaddress#screentip

The following table explains each part.

Part	Description	Optional?
displaytext	The text that you see in the field or control. For example, you might want to display a descriptive name for the World Wide Web site or object specified by the address and the subaddress.	Yes
Address	An absolute or relative path to a target document. An absolute path is a fully qualified URL or UNC path to a document. For data access pages, a relative path is a path that is related to the saved location of the page. For other database objects, a relative path is a path that is related to the base path that is specified in the Hyperlink Base setting in the DatabaseName dialog box (available by clicking Database Properties on the File menu) or to the current database path.	No, unless subaddress points to an object in the current .mdb file or .adp
subaddress	The location in the file or page. For example, you might want to point to a particular form or report in a Microsoft Access database, or a particular bookmark in a Microsoft Word document. For information on the correct syntax to use for each type of document, click .	Yes
screentip	The text that appears when you rest the pointer over a hyperlink.	Yes

Note   In a field or text box that formats the hyperlink address as a hyperlink, Microsoft Access doesn't display all four parts in the field or control. If you want to see the whole hyperlink address, use the keyboard to place the insertion point in the field or control (so you don't follow the link), and press F2.

• If you enter displaytext, Microsoft Access doesn't show any of the rest of the address following the display text.
  
  
• If you don't enter displaytext, Microsoft Access displays just the address.
  
  
• Subaddress is displayed only if there is no display text or address.
  
  
• The ScreenTip that is displayed for a hyperlink on a data access page is defined for the hyperlink control, so a ScreenTip that you enter as part of the address won’t be displayed on the data access page.

See a list of examples of hyperlink addresses.