How to Change Data Type in Microsoft Access
- George Apostolov
- 05 Sep 2025
Guide
Open your Access database.
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'.
In 'Design View', find the field you want to modify in the 'Field Name' column.
In the 'Data Type' column next to the 'Field Name', click the dropdown menu.
Select the new data type for the field.
Click the 'Save' button to save your changes.
Create your first interactive demo in minutes
No credit card required • Start building today


