The information in this article applies to:
SUMMARY
Novice: Requires knowledge of the user interface on single-user computers.
When you want to edit the information in a Hyperlink field in a table,
if you open the table and click in the field to change it, that activates
the link. This article describes methods you can use to edit a Hyperlink
field and describes the different parts of a Hyperlink data type.
MORE INFORMATION
In Microsoft Access 97, you use Hyperlink fields to store links to other
objects in a Microsoft Access database, links to other files on your hard
drive or network, or links to intranet and Internet web addresses. Each
Hyperlink field can store three pieces of information about a link,
separated by number (#) symbols, in the format
DisplayText#Address#SubAddress.
- DisplayText is the text that you see in the field or form control
- Address is the path to a target document (for example, the path to a
Microsoft Word document on your network, or the address of a web page
on the Internet)
- SubAddress is the location in the file or page (for example, a bookmark
in a Microsoft Word document, or the name of a report in a Microsoft
Access database)
NOTE: When you view a Hyperlink field in the Datasheet view of a table, or
in a bound text box on a form, all you see is the DisplayText portion of
the field. If there is no DisplayText, then you see the Address portion of
the field; if there is no Address, then you see the SubAddress portion of
the field.
For Hyperlink fields in a table, you click in the field to activate the
link. If you want to edit the DisplayText, Address, or SubAddress portions
of a Hyperlink field, use one of the following methods.
Method 1: Use the Edit Hyperlink Dialog Box
- Open the table containing the hyperlink in Datasheet view, or open a
form based on the table in Form view.
- Using the right mouse button (right-click), click in the hyperlink
field to display a shortcut menu.
- If you want to change only the DisplayText portion of the field, point
to Hyperlink on the shortcut menu, and then type in the Display Text
box.
If you want to change the Address or SubAddress portion of the field,
click Edit Hyperlink. In the Edit Hyperlink dialog box, type the
Address in the Link to File or URL box and type the SubAddress in the
Named Location in File (Optional) box. Click OK.
Method 2: Tab to the Field
- Open the table containing the hyperlink in Datasheet view, or open a
form based on the table in Form view.
- Place the insertion point in a field prior to the Hyperlink field, and
then press the TAB key until the cursor moves to the Hyperlink field.
- Press the F2 key to see the complete contents of the Hyperlink field,
and then edit the field.
Method 3: Click in the Field
This method may require some practice.
- Open the table containing the hyperlink in Datasheet view, or open a
form based on the table in Form view.
- Note that when you position the mouse pointer over a Hyperlink field,
the pointer changes to a hand with a pointing finger. If you click when
that pointer is displayed, the link is activated.
- To edit a hyperlink in a table, position the mouse pointer over the
upper or left edge of the Hyperlink field until it resembles a large
plus symbol (+), and then click.
To edit a hyperlink bound to a text box on a form, position the mouse
pointer over an edge of the Hyperlink field in a way that does not
change the pointer to a hand with a pointing finger, and then click.
- Press the F2 key to see the complete contents of the Hyperlink field,
and then edit the field.
REFERENCES
For more information about using hyperlinks, search the Help Index for
"Hyperlink data type," or ask the Microsoft Access 97 Office Assistant.
|