Change the layout of a subform

How you change the layout of a subform depends on the view in which the subform is displayed.

In Datasheet view

1. Open the main form 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. 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.

   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.

In Form view as a single or continuous form

1. Open the main form in Design view. The subform is displayed in Design view in the subform control.
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.

In PivotTable view

1. Open the main form in Form 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.

In PivotChart view

1. Open the main form in Form 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

• If you change the width of a form displayed as a subform, you must also adjust the width of the subform control on the main form.
• If the AllowDesignChanges property of the main form is set to All Views, you can change the design of the subform by using the property sheet in Form view. You can't, however, make changes to the subform control.