Click here to go to the Office Update Home page   All Products  |   Support  |   Search  |   microsoft.com Guide  
Featured on Office UpdateMicrosoft
   Home   |    Auto Update   |    What's New   |    Search Office Update   |    eServices   |    Office Update Worldwide   |    Site Help   |
 
Table of Contents

Creating a Grouped Data Access Page in Access 2000

View an Example of a Grouped Data Access Page

Step 1: Create the First Group Level

Step 2: Create the Second Group Level

Step 3: Add a Caption Section

Step 4: Add a Group Filter Control

Step 5: Align the Controls

Step 6: Add a Title, Informational Text, and a Theme

  

Step 4: Add a Group Filter Control Click here to email this to a friend.

  1. Switch to Design view.
  2. Click Header: Customers.
  3. On the View menu, click Properties, click the Format tab, and set the Height property to 0.75in.
  4. Drag the CompanyName box and its label, its expand control, and the City box and its label to the bottom of the Header: Customers section.
  5. In the field list, make sure that the Customers table is expanded.
  6. If the toolbox is not visible, click Toolbox on the View menu.
  7. Click the Dropdown List tool in the toolbox.
  8. Use the right mouse button to drag the Country field from the field list to the top of the Header: Customers section. On the shortcut menu, click Group Filter Control.

    Note  The shortcut menu does not appear unless you used the right mouse button to drag the Country field.

  9. While the Country box is still selected, click Properties on the View menu, and then click the Format tab.
  10. Set the FontWeight property to bold, and set the Width property to 1.5in.
  11. On the View menu, click Sorting and Grouping. Note that you cannot change the value of the DatePageSize property for the Customers group.
  12. Save the page and switch to Page view. Note the controls contain no data.
  13. Select a country from the Country box. Note that only customers in that country appear in the page. You can use the record navigation buttons to browse records, and you can click the expand indicator to view more details about a particular record.

    Note  Only one record at a time is displayed in a group header that contains a group filter control. However, if you remove the group filter control, the page displays the number of records specified by the DataPageSize property of that group.

For more information about creating a group filter control, type create a filter in the Office Assistant or on the Answer Wizard tab in the Help window, click Search, and then click Create a filter for a data access page.

    
 
é

© 2000 Microsoft Corporation.
All rights reserved. Terms of use.  Disclaimer.