Microsoft KB Archive/302841

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

Article ID: 302841

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition
 * Microsoft PowerPoint 2002 Standard Edition
 * Microsoft Word 2002 Standard Edition
 * Microsoft Excel 2002 Standard Edition

-



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:


 * 1) Right-click the hyperlink, and then click Edit Hyperlink.
 * 2) 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.



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.

Additional query words: pra

Keywords: kbbug kbnofix KB302841

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.