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

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.

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.

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

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.