ACC2002: Hyperlink Text Changes to Question Marks When You Paste the Text into Other Office Programs

When you paste a hyperlink from a Microsoft Access table into Microsoft Word, Microsoft Excel, or Microsoft PowerPoint, the display text of the hyperlink changes to question marks or to other unreadable characters. When you paste the hyperlink as text, the characters look as you would expect.

This behavior occurs when the display text contains characters from a code page other than 1252 (Western European).

To work around this problem, follow these steps:

1. Copy the hyperlink to the Clipboard.
2. Switch to the program and the document into which you want to insert the hyperlink.
3. On the Edit menu, click Paste as Hyperlink. For Microsoft Word only, follow these additional steps:
   
   
4. Right-click the hyperlink, and then click Edit Hyperlink.
5. In the Text to display text box, press CTRL+V to paste the text from the Clipboard, and then click OK.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Steps to Reproduce the Problem

1. In Access, create a new database.
2. Insert a new table.
3. In Design view, add a Hyperlink field to the table.
4. Switch to Datasheet view, and then type some characters from a code page other than 1252 in a cell in the Hyperlink field. For example, type Arabic, Cyrillic, Greek, or Hebrew characters.
5. Right-click these characters, point to Hyperlink, and then click Edit Hyperlink.
6. Enter an HTTP address in the Address text box, and then click OK.
7. Copy the hyperlink to the Clipboard.
8. Switch to another Office program, for example, Microsoft Word.
9. On the Edit menu, click Paste Hyperlink, or press CTRL+V to insert the hyperlink into the document.
   
   Note that the display text is pasted as question marks.