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

Article translations Article translations
Article ID: 981301 - View products that this article applies to.
Expand all | Collapse all

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.

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.

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.

Properties

Article ID: 981301 - Last Review: September 12, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Access 2010
Keywords: 
kbtshoot kbsurveynew kbprb KB981301

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com