Knowledge Base

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

Article ID: 120059

Article Last Modified on 6/25/2002


APPLIES TO


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.

Additional query words: export grayed

Keywords: kbprb kbusage KB120059