ACC2: No Way to Specify Page Range Using Output To Command (120059)



The information in this article applies to:

  • Microsoft Access 2.0

This article was previously published under Q120059
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

You can use the Output To command in Microsoft Access to save the output of a table, a query, a form, a report, or a module in one of the following file formats:
  • Microsoft Excel (.XLS)
  • Rich Text Format (.RTF)
  • MS-DOS Text (.TXT)
When you use the Output To command with a report you cannot specify the range of pages that you want. The entire report is output to the file.

RESOLUTION

To work around this behavior, base the report on a query that limits the report's output to the records you want. For example, use a query that limits the records in the report to the top 10 records.

MORE INFORMATION

When you choose Output To from the File menu, the All and Selection buttons are unavailable (appear dimmed) because Microsoft Access does not support specifying a range for the output.

REFERENCES

For more information about the Output To command, search for "Output To," and then "Output To Command" using the Microsoft Access Help menu.

Modification Type:MajorLast Reviewed:6/25/2002
Keywords:kbprb kbusage KB120059