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

ID: Q120059


The information in this article applies to:
  • Microsoft Access 2.0


SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

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 : kbusage FmrHowto
Version : 2.0
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: April 7, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.