How to Resize Columns in a Microsoft Access Table

How to Resize Columns in a Microsoft Access Table

Introduction

Instructions

Resizing by Dragging

Steps

1

Step One

Open your database file in Microsoft Access.

2

Step Two

Use the F11 key to open the Database window.

3

Step Three

Click on the Table tab, then click Open. A listing of tables appears.

4

Step Four

Select the table you want to modify, then click Open.

5

Step Five

Click in the label or title of the column that you want to resize.

6

Step Six

Move your cursor to the edge of the column. The cursor turns into a cross shape.

7

Step Seven

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

Steps

1

Step One

With your table open, click in the label or title of the column that you want to resize.

2

Step Two

Select Column Width from the Format menu in the toolbar.

3

Step Three

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.

Overall Things You'll Need

• Microsoft Access