How to Resize Columns in a Microsoft Access Table
You can resize your Access columns two ways: by dragging or with a menu command. Dragging is quicker, but you can be more precise with the menu. These instructions work for Microsoft Access 97.
Other People Are Reading
Instructions
-
Resizing by Dragging
-
1
Open your database file in Microsoft Access.
-
2
Use the F11 key to open the Database window.
-
-
3
Click on the Table tab, then click Open. A listing of tables appears.
-
4
Select the table you want to modify, then click Open.
-
5
Click in the label or title of the column that you want to resize.
-
6
Move your cursor to the edge of the column. The cursor turns into a cross shape.
-
7
When the cursor is a cross, grab the edge of the column and drag it to the width you want.
Resizing From the Format Menu
-
8
With your table open, click in the label or title of the column that you want to resize.
-
9
Select Column Width from the Format menu in the toolbar.
-
10
Enter the exact width that you want the column to be. Alternatively, select Best Fit, which adjusts for the column's content.
-
1
Tips & Warnings
If you set the width at a standard size, the column will appear at that size regardless of the data that you enter.
