How to Resize Columns in a Microsoft Access Table

Posted by Anonymous , 9/4/2007 Tags:ResizeColumnsMicrosoftAccessTable

Story Highlights

Introduction You can resize your Access columns two ways: by dragging or with a menu command.

Adjust font size:
Desrease font
Enlarge font

Introduction

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.

Instructions

Difficulty: Easy

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
Comments
Tools: |