Navigate to a file or Web page on a network, an intranet, or the Internet
Send an e-mail message
Start a file transfer, such as a download or an FTP process
When you point to text or a picture that contains a hyperlink, the pointer becomes a hand 
, indicating that it is something you can click. When a site visitor clicks the hyperlink, the destination is displayed, opened, or run, depending on the type of destination. For example, a hyperlink to a sound file opens the file in a media player, and a hyperlink to a Web page displays the page in a Web browser.
A hyperlink address can have up to four parts that are separated by the number sign (#):
| Part | Description |
|---|---|
| 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. This is an optional field. |
| address | An absolute or relative path to a target document. An absolute path is a fully qualified URL or UNC path to a document. |
| subaddress | The location in the file or page. For example, you might want to point to a particular bookmark in a Word document. This is an optional field. |
| screentip | The text that appears when you rest the pointer on a hyperlink. This is an optional field. |
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, select the insertion point and press F2.
- If you enter displaytext, the data access page doesn't show the rest of the address following the display text.
- If you don't enter displaytext, the page displays just the address.
- Subaddress is displayed only if there is no display text or address.
| To jump to a location in this type of file |
Enter |
|---|---|
| Microsoft Word | A bookmark name |
| Microsoft Excel | A defined name or a sheet!range. For example, type sheet1!A2 to jump to cell A2 in sheet 1. |
| Microsoft PowerPoint | A slide number |
| HTML document | A bookmark name (defined by using the NAME attribute of the <A> tag) |
Examples of hyperlink addresses
The following examples display the hyperlink address and what they point to. Note that URLs use forward slashes (/) and UNC paths use backward slashes (\).
Microsoft Corporation#http://www.microsoft.com#
The Microsoft home page on the Web. Displayed as "Microsoft Corporation."
#http://www.microsoft.com#
The Microsoft home page on the Web.
#http://www.microsoft.com#sample#
The Name tag called "sample" in the .htm document for the Microsoft home page. Name is an attribute of some tags in .htm pages.
#\\northwind\public\products.doc##List of discounted products
A Microsoft Word file called Products.doc in the public folder on the Northwind server. The ScreenTip is "List of discounted products."
Resume#c:\windows\personal \resume.doc#
A Word file called Resume.doc located in the C:\Windows\Personal folder. Displayed as "Resume."
#c:\windows\personal\resume.doc#
The same Resume.doc file located in the C:\Windows\Personal folder. The path name will be displayed because no display text is included.
#c:\windows\personal\resume.doc#Qualifications
The bookmark called "Qualifications" in the Resume.doc file.
To make it easier to enter a hyperlink address, Microsoft Access allows you to omit certain parts of an address. For example:
- If you type http://example.microsoft.com, Access recognizes the "http:" protocol and translates the address to #http://example.microsoft.com#. (You don't have to enter the number signs (#) yourself.)
- If the text that you enter doesn't include a number sign (#), a protocol (such as "http:"), or a reference to an object in the current database, Access assumes the text entered is display text and appends "http://" to the same text for the address. For example, if you type example.microsoft.com, Access translates the address as example.microsoft.com#http://example.microsoft.com#.