ACC2000: Hyperlink Data Type Does Not Make Real Hyperlink on Page (200711)

RESOLUTION

To create hyperlinks on a page from a Hyperlink data type, use one of the following methods.

Method 1

1. Create a query that contains all the fields for your page, except for the Hyperlink field.
2. Add the following formula to the query, instead of the Hyperlink field:

   Expr1: HyperlinkPart([field name],2)

3. Create your page and use the query as the record source, instead of the table; then, open the page in Design view.
4. Add fields and controls as you usually do, except for the expression that you created in step 2.
5. To add the hyperlink expression, click the Bound Hyperlink tool in the tool box.
6. Click and drag the expression that you created in step 2 to the page.

NOTE: These steps create a valid hyperlink. However, the name on the page is always the name of the expression in the query.

Method 2

To use this method, you must add the hyperlink field to the page before you set Control Source or Hyperlink properties of the Bound Hyperlink control. You can remove this field, after setting the Control Source and Hyperlink properties, or hide this field if you do not want it to show in the page.

Note: In some situations this method does not work. If you cannot get this method to work, follow the steps in Method 1.

1. Create a new data access page in Design view that is based on your table that has the Hyperlink field. This field should have the data type set to Hyperlink.
2. If the toolbox is not displayed, click Toolbox on the View menu.
3. Click the Bound Hyperlink control in the toolbox, and then click the page to add the hyperlink.
4. View the property sheet for the Bound Hyperlink control.
5. On the Data tab, type the following expression in the ControlSource property:

   =document.all("msodsc").hyperlinkpart([HyperlinkField],2)

   Press ENTER to commit the change.
6. Click the Hyperlink tab.
7. Type the following expression in the ControlSource property:

   =document.all("msodsc").hyperlinkpart([HyperlinkField],2)

   Press ENTER to commit the change.
   
   NOTE: You must type this expression on both the Data and the Hyperlink tabs for it to work.