Microsoft KB Archive/120059

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

Article ID: 120059

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



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.

