Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

The screen-tip text of a URL in a hyperlink field in an Access 2010 database is removed automatically after you publish the database


View products that this article applies to.

Symptoms

Consider the following scenario:
  • You have a computer that is running a Microsoft Access 2010 database.
  • In this database, you have a hyperlink field in a table.
  • You publish the database to a SharePoint site.
In this scenario, the screen-tip text of the URL in the hyperlink field is removed automatically.

↑ Back to the top


Cause

This problem occurs because SharePoint does not support the screen-tip part of hyperlink fields.

Note SharePoint supports only hyperlink addresses and text descriptions for hyperlink fields. Each part can be up to 255 characters long.

↑ Back to the top


Workaround

A hyperlink field can have up to four parts that are separated by the number sign (#) as follows:
displaytext#address#subaddress#screen-tip
The following example includes the display text, the address, and the screen-tip parts:

Microsoft Corporation#http://example.microsoft.com/#Example page for Microsoft Corporation
Note In this example, the subaddress part is omitted.

To work around this problem, put the text that you want to display in the screen-tip part to the display text part.

↑ Back to the top


Keywords: KB981301, kbprb, kbsurveynew, kbtshoot

↑ Back to the top

Article Info
Article ID : 981301
Revision : 4
Created on : 9/12/2011
Published on : 9/12/2011
Exists online : False
Views : 46