ACC2002: Manually Set IsHyperlink Property to Yes When You Add a Hyperlink Field to a Form (287434)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q287434
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

You notice that a Hyperlink field appears with a pound sign (#) preceding the URL in Form view. When you switch to Design view, the IsHyperlink field is set to No, even though it was set to Yes before you changed views.

CAUSE

This behavior occurs when all of the following conditions are true:
  • You create a new table in a Microsoft SQL Server 2000 database.
  • The new table contains a Char field with the Hyperlink property set to Yes.
  • You add the Hyperlink field to a new form, and then switch to Form view.

RESOLUTION

Manually set the IsHyperlink property on the Format tab to Yes.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Create a new table named T1 in a SQL Server 2000 database. Include a field named testfield as char(50). Set the Hyperlink field for the testfield field to Yes.
  2. In Datasheet view, add a hyperlink to the table. For example, type http://www.microsoft.com/data.
  3. Create a new form in Design view that is based on table T1.
  4. Drag the testfield Hyperlink field from the field list to the detail section of the form.
  5. Switch to Form view. Note that a pound sign (#) precedes the URL.
  6. Switch back to Design view. Note that the IsHyperlink property on the Format tab is set to No.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbprb KB287434
©2003 Microsoft Corporation. All rights reserved.