Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 200473 - Last Review: June 28, 2004 - Revision: 2.0
ACC2000: Explanation of the New Group Properties in the Sorting and Grouping Dialog Box of a Data Access Page
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).
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.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate