ACC2000: OutputTo Message Box Displays Incorrect AutoReport Name (197375)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q197375
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.

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 Tables under Objects and select the Products table. On the Insert menu, click AutoReport.
  3. Save the newly created report as Products1, and then close it.
  4. In the Database window, click Reports under Objects, and select the Products1 report.
  5. On the File menu, click Export.
  6. In the Export Report 'Products1' To dialog box, click Rich Text Format(*.rtf) in the Save As Type box, and then click Save. 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, click Microsoft Access Help on the Help menu, type export data to another database or file format in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbdocerr kbprb KB197375