# How to Change Data Type in Microsoft Access

> To change a data type in Microsoft Access, open your database and switch to Design View by right-clicking the table in the Navigation Pane. Locate the target field in the Field Name column, open the dropdown menu in the Data Type column, choose the new data type, and click the Save button.

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

## Steps

1. Open your Access database.
2. Locate the table containing the field whose data type you want to change. Right-click on the table name in the 'Navigation Pane' and select 'Design View'.
3. In 'Design View', find the field you want to modify in the 'Field Name' column.
4. In the 'Data Type' column next to the 'Field Name', click the dropdown menu.
5. Select the new data type for the field.
6. Click the 'Save' button to save your changes.