Change the layout of a subform displayed in Datasheet view

In Form view of the main form, you can do any 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.

Notes  

• If you need to adjust the size of the subform itself, size the subform control in Design view of the main form.
  
  
• If the AllowDesignChanges property of the main form is set to All Views, you can change the design of the subform datasheet by using the property sheet in Form view.