ACC97: OutputTo Message Box Displays Incorrect AutoReport Name

• Microsoft Access 97

SYMPTOMS

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

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

This behavior is by design.

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

1. Open the sample database Northwind.mdb.

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

3. Save the newly created report as "Products1" (without the quotation marks), and then close it.

4. In the Database window, click the Reports tab, and click the Products1 report.

5. On the File menu, click Save As/Export. In the Save As box, click "To an External File or Database", and then click OK.

6. 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"
   

REFERENCES