Table of contents
Collapse the table of content
Expand the table of content

OutputAllFields Property

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Applies to: Access 2013 | Access 2016

You can use the OutputAllFields property to show all fields in the query's underlying data source and in the field list of a form or report. Setting this property is an easy way to show all fields without having to click the Show box in the query design grid for each field in the query.

Note The OutputAllFields property applies only to append, make-table, and select queries.


The OutputAllFields property uses the following settings.

YesDisplays all the fields in the underlying tables and in the field list of a form or report.
No(Default) Displays only fields that have the Show box selected in the query design grid.

You can set this property only by using the query's property sheet.

Note The use of an asterisk () in an SQL statement in place of a field name is the equivalent of setting the **OutputAllFields* property to Yes.


When the OutputAllFields property is set to Yes, the only fields you need to include in the query design grid are those that you want to sort on or specify criteria for.

When you save a filter as a query, Microsoft Access sets the OutputAllFields property to Yes.

Access for developers forum on MSDN
Access help on
Access help on
Search for specific Access error codes on Bing
Access forums on UtterAccess
Access wiki on UtterAcess
Access developer and VBA programming help center (FMS)
Access posts on StackOverflow

© 2018 Microsoft