Change the layout of a subform

How you change the layout of a subform (subform: A form contained within another form or a report.) depends on the view in which the subform is displayed.

ShowIn Datasheet view

  1. Open the main form (main form: A form that contains one or more subforms.) in Datasheet view.
  2. Do one or more of the following in the subform:

To change the width of a column, drag the right edge of the column selector (column selector: The horizontal bar at the top of a column. You can click a column selector to select an entire column in the query design grid or the filter design grid.). To automatically size the column to fit its data, double-click the right edge of the column selector.

To change the order of columns, click a column heading to select the column. Then click the column heading again, hold down the mouse button, and drag the column to a new location.

To change the height of all the rows, drag the bottom edge of the row selector (row selector: A small box or bar that, when clicked, selects an entire row in table or macro Design view, or when you sort and group records in report Design view.).

To hide a column, click anywhere in the column, and then click Hide Columns on the Format menu.

To show a hidden column, click Unhide Columns on the Format menu, and select the check box of the column you want to show.

To freeze a column, click anywhere in the column, and then click Freeze Columns on the Format menu.

ShowIn Form view as a single or continuous form

  1. Open the main form (main form: A form that contains one or more subforms.) in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.). The subform is displayed in Design view in the subform control (subform/subreport control: A control that displays a subform in a form or a subform or a subreport in a report.).
  2. Right-click the subform control and click Subform in New Window to open it in a separate window.
  3. Make changes to the subform's design.
  4. Save and close the subform window.
  5. Switch the main form to Form view to see the changes.

ShowIn PivotTable view

  1. Open the main form in Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.). The subform is displayed in its default view.
  2. On the View menu, point to Subforms, and then click PivotTable.
  3. Add fields from the field list to the filter, row, column, or detail area. You can also move fields from one area to another.
  4. Customize the data that is displayed in the view by filtering, grouping, or sorting data.

ShowIn PivotChart view

  1. Open the main form in Form view (Form view: A view that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.). The subform is displayed in its default view.
  2. On the View menu, point to Subforms, and then click PivotChart.
  3. Add fields from the field list to the filter, category, series, or data area. You can also move fields from one area to another.
  4. Customize the data that is displayed in the view by filtering, grouping, or sorting data.

 Notes 

 
 
Applies to:
Access 2003