ACC97: HyperLink Address Not Updated Correctly When Edited

• Microsoft Access 97

SYMPTOMS

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

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.

CAUSE

This behavior is by design.

RESOLUTION

When you change a hyperlink address directly or by using 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, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q159327
   TITLE     : ACC97: How to Edit Data in a Hyperlink Field in a Table

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the Northwind database and create the following new table:

         Table: Table1
         --------------------
         Field Name: Field1
         Date Type: Hyperlink
   

2. Open the table in Datasheet view and type

         http://support.microsoft.com/support/Access/default.asp
   

   in the Hyperlink field.

3. In the second record type

         support.microsoft.com/support/Excel/default.asp
   

4. Return to the first record and using the right mouse button (right-click), click the hyperlink, point to Hyperlink on the shortcut menu, and then click Edit Hyperlink.

5. Delete Access/default.asp from the hyperlink. Note that the address change is reflected correctly in the datasheet.

6. Go to the second record and using the right-mouse button, 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.

REFERENCES

For more information about creating hyperlinks, search the Help Index for “Hyperlink fields, creating,” or ask the Microsoft Access 97 Office Assistant.

Keywords          : IntLink kbui kbusage
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb