ACC97: OutputTo Message Box Displays Incorrect AutoReport Name

ID: Q163716

The information in this article applies to:

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.

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

For more information about outputting a report, search the Help Index for "OutputTo," or ask the Microsoft Access 97 Office Assistant.

Additional query words:

Keywords          : kbusage kbdta
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb

Last Reviewed: December 15, 1998