Microsoft KB Archive/92650

{|
 * width="100%"|

ACC1x: OLE Excel Format Changes When Updated in Microsoft Access

 * }

Q92650

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
New OLE objects created in Microsoft Excel version 4.0 are displayed without row or column headings in Microsoft Access version 1.x. Once the object has been updated, the display changes and row and column headings are displayed.

STATUS
This behavior no longer occurs in applications using OLE 2.0, such as Microsoft Access version 2.0 and Microsoft Excel version 5.0.

Steps To Reproduce Behavior

 * 1) Start Microsoft Excel.
 * 2) Enter Test in cell A1.
 * 3) Select cell A1 and choose Copy from the Edit menu.
 * 4) Start Microsoft Access and open a database.
 * 5) Create a new form and choose Paste from the Edit menu. This creates an OLE Object which displays cell A1.
 * 6) Double-click on the OLE Object to activate Excel.
 * 7) Modify the contents of cell A1.
 * 8) From the File menu choose Update.
 * 9) Activate Microsoft Access.

The OLE Object now displays row and column headings. You may need to resize the OLE Object to see the updated contents of cell A1.

Keywords :

Issue type : kbprb

Technology :