How to Edit Hyperlinks in an Access 2007 Database
As discussed in the previous article, Access 2007 hyperlinks contain one mandatory and three optional components. Over time, you may find it necessary to edit your Access hyperlinks to account for changes in document locations, changes in how hyperlinks will be used in the database, and changes that occur when more information is available about a hyperlink.
It is not necessary to type in a hyperlink again when you want to change something. Access 2007 has a built-in hyperlink editor function that can save you time when hyperlink information has to change. This built-in hyperlink editor is also useful for correcting errors in the formation of hyperlinks.
Start by opening the table that contains the hyperlink you want to edit. Right click on the hyperlink and in the box that opens, click on HYPERLINK and then click on EDIT HYPERLINK (see Figure 1). This opens the EDIT HYPERLINK window (see Figure 2).
In this window, you can change just about anything about the hyperlinks in your Access 2007 database. Recall that the only mandatory component of a hyperlink is the address itself. You can change the address using the ADDRESS box located at the bottom of the window. You can use the LOOK IN box to locate files locally. Also, notice that there is a button to REMOVE HYPERLINK if you decide you no longer need the link.
At the top of the window, you can change the text that displays in the cell where the hyperlink resides. This text can be anything and is useful when a Web address is quite long or if the link address itself is not descriptive enough to let a user of the database know where the hyperlink goes when clicked.
In the top right potion of the window is the SCREEN TIP button where you can specify what text Access 2007 will display when a user hovers his/her mouse over the hyperlink. Notice that these four things that you can change about a hyperlink are exactly the four components discussed in the previous article in this series.