ACC2000: Hyperlink Data Type Doesn't Make Real Hyperlink on Page

ID: Q200711

The information in this article applies to:
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).


SYMPTOMS

If you place a control bound to a Hyperlink field on a data access page, you can see the address, but it does not function as a hyperlink.


RESOLUTION

When you want to create hyperlinks on a page from a Hyperlink data type, follow these steps:

  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:


    3. Expr1: Mid([field name],2,Len([field name])-2)
  3. Create your page using the query as the record source, instead of the table, and then open the page in Design view.


  4. Add fields and controls as you normally would, 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.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Access.

Additional query words: DAP pra boundhyperlink URL URLs

Keywords : kbdta AccDAP DAPProb
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: December 2, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.