Microsoft KB Archive/163716

= ACC97: OutputTo Message Box Displays Incorrect AutoReport Name =

Article ID: 163716

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q163716



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



SYMPTOMS
When you export an AutoReport to an external file, the report name that is displayed in the OutputTo message box is not the name that you gave to the AutoReport when you saved it.



CAUSE
When you use the AutoReport or AutoForm command, the Caption property of the new report or form is set to the name of the object from which it is created. The Caption property is used in the OutputTo message box when the report or form is exported.



STATUS


MORE INFORMATION
When you create an AutoReport or AutoForm, the report or form will have the name contained in the Caption property of the table or query from which it is created.

For example, if you create an AutoReport based on the Products table in the sample database Northwind.mdb, the Caption property of the new report will be Products. If you save this report as Products1, the report will appear as Products1 in the Database window; however, when you open the report or output the report, you will see the name Products. If you want the names to match, you must change the Caption property of the report to the name that appears in the Database window.

Steps to Reproduce Behavior
 Open the sample database Northwind.mdb. In the Database window, click the Tables tab and select the Products table. Click the arrow on the New Objects button on the tool bar, and then click AutoReport on the menu that appears. Save the newly created report as "Products1" (without the quotation marks), and then close it. In the Database window, click the Reports tab, and click the Products1 report. On the File menu, click Save As/Export. In the Save As box, click "To an External File or Database", and then click OK.</li> In the "Save Report 'Products' In" box, click Rich Text Format(*.rtf) in the Save As Type box, and then click Export. Note that the following message box is displayed:

Now outputting "Products" to the file "C:\My Documents\Products1.RTF"

</li></ol>

<div class="references_section">