If datasheet view isn't working, switch your table over to design view for a better perspective of your data. Open or create the Access database you want to edit. Click the tab of the table you ...

Launch Microsoft Access. On the navigation pane on the left, click the table that contains the field size you want to change. Then click View on the Home tab and select Design view .