How to Adjust All Columns to Best Fit in Access
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.
Click the Microsoft Office ribbon at the top-left corner of the screen.
Click the "Records" section.
Click "More" from the drop-down menu.
Choose "Column Width."
Click "Best Fit."
Double-click the border of the column header to adjust the column width automatically.