Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.

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).

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB302841, kbnofix, kbbug

↑ Back to the top

Article Info
Article ID : 302841
Revision : 3
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 364