Question

how to change the data type of field​

Answer 1

In the Navigation Pane, locate and double-click the table that you want to change.

Access opens the table in Datasheet view.

Select the field (the column) that you want to change.

On the Fields tab, in the Properties group, click the arrow in the drop-down list next to Data Type, and then select a data type.

Save your changes.