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.
In Datasheet view
- Open the main form (main form: A form that contains one or more subforms.) in Datasheet view.
- 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.
In Form view as a single or continuous form
In PivotTable view
In PivotChart view