Enter a hyperlink into an existing hyperlink address

There are several ways to change the destination (destination: General term for the name of the element you go to from a hyperlink.) address of an existing hyperlink. The method that you choose will depend on the object that contains the hyperlink.

ShowEnter a hyperlink to an object in the current Access file

  1. In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) (.mdb) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) (.adp), open the table or query in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), or the form in Datasheet or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.).
  2. Place the insertion point in the hyperlink field in the datasheet, or in the text box or combo box, that accepts hyperlinks on the form.
  3. Click Insert Hyperlink Button image on the Design toolbar.
  4. In the Insert Hyperlink dialog box, click Object in this database under Link to.
  5. In the Text to display box, type the text that you want displayed in the field or text box. If you leave the box blank, then Access will use the object type and object name as the display text.
  6. Click ScreenTip, and type the text that you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip box blank, Access displays the object type and object name as the ScreenTip.
  7. Select the database object that you want to link to from the list.

Access adds the hyperlink to the field or control. You can click the hyperlink to open the target object.

ShowEnter a hyperlink that links to text in a Microsoft Office document or data access page

  1. Open the data access page or Office document that you want to link to. For example, open a Microsoft Word document.

 Note   You cannot link to text in other Access objects, only to text in data access pages.

  1. Select the text that you want to link to.
  2. On the Edit menu, click Copy.
  3. In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) (.mdb) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) (.adp), open the table or query in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), or the form in Datasheet or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.).
  4. Place the insertion point in the hyperlink field in the datasheet, or in the text box or other control, that accepts hyperlinks on the form.
  5. Click Paste on the Edit menu.

Access adds the hyperlink to the field or control. On a form or datasheet, you can click the hyperlink to open the target document or page.

ShowEnter a hyperlink in a table, query, or form by pasting a hyperlink or hyperlink address

  1. Navigate to a hyperlink or hyperlink address in one of the following ways:
    • Open a Microsoft Office document that contains an existing hyperlink.
    • Open a document that was created with any application and contains a valid hyperlink address that is not defined as a hyperlink.
    • Open a Web browser such as Microsoft Internet Explorer.
  2. Do one of the following:
    • In an Office document, right-click the defined hyperlink. Point to Hyperlink on the shortcut menu, and then click Copy Hyperlink.
    • In any document, select the hyperlink address, and then click Copy on the Edit menu.
    • In the Web browser, select the address for the current page or select a valid hyperlink address anywhere on a page, right-click, and then click Copy or Copy Shortcut.

 Note   If you're copying a defined hyperlink from an Office document, make sure to copy just the hyperlink. If you copy characters that surround but aren't part of the hyperlink, Access will link to the text that you selected instead of using the address of the hyperlink.

  1. In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) (.mdb) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) (.adp), open the table or query in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), or the form in Datasheet or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.).
  2. Place the insertion point in the hyperlink field in the datasheet, or in the text box or other control, that accepts hyperlinks on the form.
  3. Do one of the following:
    • To paste a defined hyperlink, click Paste as Hyperlink on the Edit menu.
    • To paste a hyperlink address that isn't defined as a hyperlink, click Paste on the Edit menu. When you paste an address this way, Access recognizes the protocol in the address and converts the text to a hyperlink.

Access adds the hyperlink to the field or control. You can click the hyperlink to open the target document or Web page.

ShowEnter a hyperlink in a data access page by pasting a hyperlink or hyperlink address

  1. Navigate to a hyperlink or hyperlink address in one of the following ways:
    • Open a document that contains the hyperlink or the hyperlink address.
    • In a Web browser, such as Microsoft Internet Explorer, go to the page containing the hyperlink or hyperlink address.
  2. Do one of the following:
    • In a document, select the defined hyperlink or the hyperlink address and then click Copy on the Edit menu.
    • In a Web browser, select the address for the current page or select a valid hyperlink address anywhere on a page, right-click the selection, and then click Copy or Copy Shortcut on the shortcut menu.
  3. Open a data access page in your Web browser.
  4. Place the insertion point in the text box that accepts hyperlinks on the page.
  5. On the Edit menu, click Paste.

On a data access page, the text box in which you enter a hyperlink address doesn't format the address as a hyperlink.

ShowTip

To see the hyperlink address displayed as a formatted hyperlink, refresh the page in your Web browser.

ShowEnter a hyperlink to a new data access page in a datasheet or form

  1. In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) (.mdb) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) (.adp), open the table or query in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), or the form in Datasheet or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.).
  2. Place the insertion point in the hyperlink field in the datasheet, or in the text box or combo box, that accepts hyperlinks on the form.
  3. Click Insert Hyperlink Button image on the Design toolbar.
  4. In the Insert Hyperlink dialog box, click Create new page under Link to.
  5. In the Text to display box, type the text that you want displayed in the field or text box. If you leave the box blank, Access will use the hyperlink address as the display text.
  6. Click ScreenTip and type the text that you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip box blank, Access will display the hyperlink address as the ScreenTip.
  7. In the Name of new document box, type a name and the three-letter file name extension of the type of file that you want to create. If you omit the extension or enter .htm or .html, Access will create a new data access page.
  8. Access creates the new document in the current folder. To specify a different location, click Change.
  9. Select an option under When to edit. You can edit the new document immediately or wait until later.

Access adds the hyperlink to the field or control. You can click the hyperlink to open the target document.

ShowEnter a hyperlink by dragging an Internet shortcut

  1. In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) (.mdb) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) (.adp), open the table or query in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), the form in Datasheet view or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.), or the data access page in Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Microsoft Internet Explorer 5.0 or later.).
  2. Locate the desired Internet shortcut (such as an icon on your desktop).
  3. Select the Internet shortcut.
  4. Left-click the hyperlink and drag it to the hyperlink field in the datasheet or to the text box or other control that accepts hyperlinks on the form or data access page.

Access adds the hyperlink to the field or control. On a form or datasheet, you can click the hyperlink to open the destination document or Web page. On a data access page, the text box into which you enter a hyperlink address doesn't format the address as a hyperlink.

ShowTip

To see the hyperlink address displayed as a formatted hyperlink, refresh the page in your Web browser.

ShowEnter a hyperlink that creates an e-mail message in Form view or Datasheet view

  1. In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) (.mdb) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) (.adp), open the table or query in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), or the form in Datasheet or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.).
  2. Place the insertion point in the hyperlink field in the datasheet, or in the text box or combo box, that accepts hyperlinks on the form.
  3. Click Insert Hyperlink Button image on the Design toolbar.
  4. In the Insert Hyperlink dialog box, click E-mail Address under Link to.
  5. In the Text to display box, type the text that you want displayed in the field or text box. If you leave the box blank, Access will use the e-mail address and subject as the display text.
  6. Click ScreenTip, and type the text that you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip box blank, Access will display the e-mail address and subject as the ScreenTip.
  7. In the E-mail address box, type an e-mail address. You can also select an address from the Recently used e-mail addresses list.
  8. In the Subject box, type the information that you want to appear in the Subject field of the e-mail message.

When you click the hyperlink, Microsoft Access opens your mail program and creates a new message, with the address and subject filled in.

 Note   Some Web browsers and e-mail programs might not recognize the subject line.

ShowEnter a hyperlink to an existing file or Web page

  1. In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) (.mdb) or Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) (.adp), open the table or query in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.), or the form in Datasheet or Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.).
  2. Place the insertion point in the hyperlink field in the datasheet, or in the text box or combo box, that accepts hyperlinks on the form.
  3. Click Insert Hyperlink Button image on the Design toolbar.
  4. In the Insert Hyperlink dialog box, click Existing file or Web page under Link to.
  5. In the Text to display box, type the display text for the hyperlink. If you leave the box blank, Access will use the hyperlink address as the display text.
  6. Click ScreenTip, and then type the text that you want to appear when the user rests the pointer on the hyperlink. If you leave the ScreenTip box blank, Access will display the hyperlink address as the ScreenTip.
  7. Do one of the following:
  8. To go to a specific location in an HTML file or to an object in the current Microsoft Access database (.mdb) or Microsoft Access project (.adp), click Bookmark. Click the bookmark (Bookmark: A property of a Recordset object or a form that contains a binary string identifying the current record.) or object you want in the list, and then click OK.
  9. Click OK in the Edit Hyperlink dialog box.

Access adds the hyperlink to the field or control. You can click the hyperlink to open the destination document, Web page, or object.

Notes

 
 
Applies to:
Access 2003