How to Adjust All Columns to Best Fit in Access

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Microsoft Access provides many powerful features that enable even non-programmers to create robust databases relatively quickly. When working with tables in an Access database, you may create fields with only a few or many characters. When viewing fields in a form or datasheet, they may be too wide or narrow for the data they contain. If the column width is too wide, it simply wastes space on your form. If it's not wide enough, you can't see all the data in the field. Using the "Best Fit" feature in Access, though, you can adjust the width of columns dynamically.


Step 1

Click the Microsoft Office ribbon at the top-left corner of the screen.

Video of the Day

Step 2

Click the "Records" section.

Step 3

Click "More" from the drop-down menu.


Step 4

Choose "Column Width."


Step 5

Click "Best Fit."

Step 6

Double-click the border of the column header to adjust the column width automatically.




Report an Issue

screenshot of the current page

Screenshot loading...