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


The information in this article applies to:

  • Microsoft Access 2002
  • Microsoft PowerPoint 2002
  • Microsoft Word 2002
  • Microsoft Excel 2002
This article was previously published under Q302841
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

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.

CAUSE

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

RESOLUTION

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.

STATUS

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

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbbug kbnofix KB302841
©2002 Microsoft Corporation. All rights reserved.