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 (#):
|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
|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)|
The following examples display the hyperlink address and what they point to. Note that URLs use forward slashes (/) and UNC paths use backward slashes (\).
The Microsoft home page on the Web. Displayed as "Microsoft Corporation."
The Microsoft home page on the Web.
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."
A Word file called Resume.doc located in the C:\Windows\Personal folder. Displayed as "Resume."
The same Resume.doc file located in the C:\Windows\Personal folder. The path name will be displayed because no display text is included.
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#.