Changing the Size of Rows and Columns

If some of the text in a column is hidden because the column is too narrow, you can increase the width of the column. You can also change the height of the rows to provide more space for the text. Unlike changing the column width, which affects only the selected column or columns, changing the row height affects all the rows in the table. You can adjust the size of columns and rows by using commands or by dragging the borders between columns or rows.

Change Column Width

Point to the border between two field selectors, and then drag the border left or right.
Right-click a field selector, and then click Column Width. Click Best Fit, or enter a new width, and then click OK.

Change Row Height

Point to the border between two row selectors, and then drag the border up or down to adjust the height of all the rows in the table.
Right-click a row selector, and then click Row Height. Enter a new height, and then click OK.

Did You Know?

You can format columns in other Access objects . These formatting steps also work for columns in queries, forms, views, or stored procedures.