Microsoft KB Archive/165627

= Hyperlink address not updated correctly when edited =

Article ID: 165627

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q165627



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you edit a hyperlink address while in Datasheet view of a table or query, and the hyperlink address does not include http: at the beginning of the address, the hyperlink data is not updated in the datasheet. However when you move the pointer over the hyperlink, the status bar text reflects the correct address.



RESOLUTION
When you change a hyperlink address directly or by using Data Access Objects (DAO) methods, you must include the http:// characters or the number sign (#) before and after the address in order to see the changes.

For more information about editing a hyperlink, click the following article number to view the article in the Microsoft Knowledge Base:

159327 How to edit data in a hyperlink field in a table



Steps to Reproduce Behavior
  Open the sample database Northwind.mdb and create the following table:

     Table: Table1 Field Name: Field1 Date Type: Hyperlink  Open the table in Datasheet view and type

http://support.microsoft.com/ph/2509/en-us/

in the Hyperlink field.  In the second record type

     support.microsoft.com/support/excel/default.asp  Return to the first record. Right-click the hyperlink, point to Hyperlink on the shortcut menu, and then click Edit Hyperlink. Delete ph/2509/en-us/ from the hyperlink. Note that the address change is reflected correctly in the datasheet.</li> Go to the second record. Right-click the hyperlink, point to Hyperlink on the shortcut menu, and then click Edit Hyperlink. Delete Excel/default.asp from the hyperlink.

Note that the change is not reflected in the hyperlink in the datasheet; however, if you move the pointer over the hyperlink, you can see the updated information in the status bar.</li></ol>

<div class="references_section">