Switch to the datasheet.
Drag the border on the right side of the column heading until the column is the width you want.
Tip To change the column width for multiple columns, select the columns whose widths you want to change. Then drag a border at the right of a selected column heading. To change the column width for all columns on the datasheet, click the Select All button, and then drag the border of any column heading.