Expand or collapse a subdatasheet

  1. Open the table, query, or form containing the subdatasheet (subdatasheet: A datasheet that is nested within another datasheet and that contains data related or joined to the first datasheet.) in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).
  2. Do one of the following:

To expand a subdatasheet for a row of a datasheet or subdatasheet, click the expand indicator (expand indicator: A button that is used to expand or collapse groups of records; it displays the plus (+) or minus (-) sign.) (+) to the left of the row.

To expand all subdatasheets in the datasheet or subdatasheet that currently has focus, point to Subdatasheet on the Format menu, and then click Expand All.

To collapse a subdatasheet for a row of a datasheet or subdatasheet, click the expand indicator (-) to the left of the row.

To collapse all subdatasheets in the datasheet or subdatasheet that currently has focus, point to Subdatasheet on the Format menu, and then click Collapse All.

 
 
Applies to:
Access 2003