- In a Microsoft Access database (.mdb) or Microsoft Access project (.adp), open the table or query in Datasheet view, or the form in Datasheet or Form view.
- 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.
- Click Insert Hyperlink
on the Design toolbar. - In the Insert Hyperlink dialog box, click Object in this database under Link to.
- 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.
- 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.
- 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.
Enter a hyperlink that links to text in a Microsoft Office document or data access page
- 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.
- Select the text that you want to link to.
- On the Edit menu, click Copy.
- In a Microsoft Access database (.mdb) or Microsoft Access project (.adp), open the table or query in Datasheet view, or the form in Datasheet or Form view.
- 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.
- 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.
Enter a hyperlink in a table, query, or form by pasting a hyperlink or hyperlink address
- 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.
- 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.
- In a Microsoft Access database (.mdb) or Microsoft Access project (.adp), open the table or query in Datasheet view, or the form in Datasheet or Form view.
- 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.
- 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.
Enter a hyperlink in a data access page by pasting a hyperlink or hyperlink address
- 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.
- 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.
- Open a data access page in your Web browser.
- Place the insertion point in the text box that accepts hyperlinks on the page.
- 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.
To see the hyperlink address displayed as a formatted hyperlink, refresh the page in your Web browser.
Enter a hyperlink to a new data access page in a datasheet or form
- In a Microsoft Access database (.mdb) or Microsoft Access project (.adp), open the table or query in Datasheet view, or the form in Datasheet or Form view.
- 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.
- Click Insert Hyperlink
on the Design toolbar.
- In the Insert Hyperlink dialog box, click Create new page under Link to.
- 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.
- 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.
- 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.
- Access creates the new document in the current folder. To specify a different location, click Change.
- 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.
Enter a hyperlink by dragging an Internet shortcut
- In a Microsoft Access database (.mdb) or Microsoft Access project (.adp), open the table or query in Datasheet view, the form in Datasheet view or Form view, or the data access page in Page view.
- Locate the desired Internet shortcut (such as an icon on your desktop).
- Select the Internet shortcut.
- 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.
To see the hyperlink address displayed as a formatted hyperlink, refresh the page in your Web browser.
Enter a hyperlink that creates an e-mail message in Form view or Datasheet view
- In a Microsoft Access database (.mdb) or Microsoft Access project (.adp), open the table or query in Datasheet view, or the form in Datasheet or Form view.
- 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.
- Click Insert Hyperlink
on the Design toolbar.
- In the Insert Hyperlink dialog box, click E-mail Address under Link to.
- 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.
- 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.
- 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.
- 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.
Enter a hyperlink to an existing file or Web page
- In a Microsoft Access database (.mdb) or Microsoft Access project (.adp), open the table or query in Datasheet view, or the form in Datasheet or Form view.
- 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.
- Click Insert Hyperlink
on the Design toolbar.
- In the Insert Hyperlink dialog box, click Existing file or Web page under Link to.
- 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.
- 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.
- Do one of the following:
- In the Address box, type a path or a URL.
- Click Current Folder, Browsed Pages or Recent Files and then click an item from the list. If you click Current Folder and don't see the object you want, select a different folder from the Look in box.
- 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 or object you want in the list, and then click OK.
- 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
- In a data access page, the text box in which you enter a hyperlink address displays the hyperlink address as a text string, not as a formatted hyperlink. The formatted address can be found in the Hyperlink property of the text box.
- The ScreenTip displayed for a hyperlink on a data access page is defined in the hyperlink control, so a ScreenTip that you enter won't be displayed on the page.
- To see a newly created hyperlink address displayed as a formatted hyperlink on the data access page, click Refresh on the Microsoft Internet Explorer toolbar.