How+To+Change+a+Field's+Size

Field columns are used every time someone is using Microsoft Access. It is important to know how to change a column size because sometimes your data will be too large for the current default size. Therefore, not all of your data will be seen unless the correct size adjustment is made. Another reason you may want to change your column size is because the data is too short for the column default. Therefore, there is an extra blank space.

Below is an example of a database that needs column size corrections.



As you can see the ProductNum column is too large, and the ProductDesc is too small. To make these corrections there are a few steps to be followed.

The steps are as follows:
 * 1) Right-click the column that needs to be adjusted
 * 2) Scroll down till you reach "Column Width"
 * 3) Click "column Width"
 * 4) Type in the desired field size
 * 5) Press Enter

Now look at the difference! Below you can now see the full Product Descriptions and there is no more extra space in the ProductNum Column.

It is as simple as that! Now your work is all neatly organize and viewable!

Karen Krouse Info0273