Microsoft KB Archive/287434

= ACC2002: Manually Set IsHyperlink Property to Yes When You Add a Hyperlink Field to a Form =

Article ID: 287434

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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.

Additional query words: pra hyperlink prb switched turned back reset put again

Keywords: kbprb KB287434

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.