# How to Change Field Size in Microsoft Access

> To change a field size in Microsoft Access, open your database, switch the desired table to Design View, and select the target field. In the Field Properties section at the bottom of the window, update the field size value with a number between 1 and 255, then click the Save button.

Canonical: https://livedemo.ai/tutorials/how-to-change-field-size-in-microsoft-access/
Apps: Microsoft
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a30f7d673bd5aa8e63c82/preview?step=1

## Steps

1. Open your Access database.
2. Locate the table where you want to change the field size.
3. Right-click on the table name in the 'Navigation Pane' and select 'Design View'.
4. In the 'Design View', find the field whose size you want to change.
5. Look at the bottom of the window in the 'Field Properties' section. Change the value of the field size.
6. Enter a number between 1 and 255 to define the maximum number of characters allowed.
7. After modifying the field size, click the 'Save' button to save the table.
