Change a field's data type
See Also
1. Open the table in Design View
2. Select the
Fields tab
3. Move to the row of the field which type you want to change
4. In the Type column, click the arrow and select the field's new type
5. Select
Save… or
Save As… from the File menu when you are ready to save the table
Note: Be careful because changing a field's type may result in the loss of that
field's data depending on how compatible the new and the old type are.