You are currently offline, waiting for your internet to reconnect

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

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: 09/12/2011 04:02:00 - Revision: 4.0

  • Microsoft Access 2010
  • kbtshoot kbsurveynew kbprb KB981301
Feedback