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.

Difficulty: Easy

Instructions

Things You'll Need:

• Microsoft Access

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.

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.