Microsoft KB Archive/200473

= ACC2000: Explanation of the New Group Properties in the Sorting and Grouping Dialog Box of a Data Access Page =

Article ID: 200473

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q200473



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
Although data access pages and reports have many grouping and sorting properties in common, there are some new properties that have been added to the Sorting and Grouping dialog box for data access pages. These new properties change the behavior of a data access page when a data access page is grouped, and even when it is not. Some of these properties are:
 * Caption Section
 * Data Page Size
 * Default Sort
 * Expanded By Default
 * Group Filter Control
 * Group Filter Field
 * Record Navigation Section

The only report property that has been removed from the Sorting and Grouping dialog box in data access pages is KeepTogether, which would not be applicable to a data access page. The rest of this article gives a brief overview of these new data access page Sorting and Grouping options.



Caption Section
Click Yes to add a caption section above the group header. This section is displayed only when the next higher group level is expanded. You cannot add any bound controls to a caption section. Click No to delete a caption section and any controls it contains.

Data Page Size
Specifies how many records you want to display at a time on the data access page for each group level. If a group level does not have a record navigation section or a record navigation control, you must set DataPageSize property to All in order to see all the records for that group level. To use a page for data entry, you can have only one group level, and you must set the DataPageSize property to 1 for that group level.

Default Sort
Use to set the default sort order of the data access page. Type the names of the fields that you want to sort by, separated by a comma. You can follow each name with a space and the keyword ASC or DESC. For example, type OrderDate DESC, OrderID ASC. If you do not specify the order, Microsoft Access sorts in ascending order.

Expanded By Default
Click Yes to open the data access page with the records in the next lower group displayed. Click No to open the page with records in the next lower group level hidden. The page will load faster in Page view and in Microsoft Internet Explorer if the ExpandedByDefault property is set to No for the highest group level on the page.

Group Filter Control
Type the name of the combo box or list box that will filter the records in this grouping level.

Group Filter Field
Type the name of the field that contains the values that you want to filter for. The field must be in the selected group record source.

Record Navigation Section
Use to display the record navigation control for the group level. A record navigation section for a group appears after the group header section if there is no footer for the group level, or after the footer if there is a footer for the group level. You cannot place bound controls in a record navigation section.

Additional query words: inf

Keywords: kbinfo kbdap KB200473

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.