Microsoft KB Archive/288152

= OLE objects do not appear in output file in Access 2002 =

Article ID: 288152

Article Last Modified on 8/10/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q288152



Novice: Requires knowledge of the user interface on single-user computers.



For a Microsoft Access 97 version of this article, see 169277.

For a Microsoft Access 2000 version of this article, see 207751.



SYMPTOMS
When you output a report from Microsoft Access to another file format, such as .rtf, .txt, .xls, or .html, an OLE object that you inserted into the report does not appear.



CAUSE
Although some output file formats, such as .rtf or .xls, do support embedded or linked OLE objects, Microsoft Access does not support outputting an OLE object to another file format.



RESOLUTION
If you have saved the OLE object separately, you can first output the report, and then insert the OLE object into the resulting file.



Steps to Reproduce the Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) In the Database window, click Reports under Objects, and then click New.
 * 3) In the New Report dialog box, click AutoReport: Tabular. In the Choose the table or query where the object's data comes from list, select the Shippers table, and then click OK. The report opens in preview mode.
 * 4) On the View menu, click Design View, and then click anywhere in the detail section of the report.
 * 5) On the Insert menu, click Object, and then in the Insert Object dialog box, click Microsoft Clip Gallery. Click OK.
 * 6) Click the Pictures tab, scroll down and click Transportation, click the Air Travel picture, and then click OK.
 * 7) On the View menu, click Print Preview. The picture appears in the detail section of the report.
 * 8) On the Tools menu, point to OfficeLinks, and then click Publish It With Microsoft Word. If the Convert File dialog box appears, click Rich Text Format (RTF), and then click OK. Note that the report opens in Microsoft Word, but that the OLE object does not appear.

