How Do You Change A Microsoft Access Fields Datatype?
You can change a datatype in a Microsoft Access field at any time. These instructions are for Access 97. Open your table in Design view. Locate the field that you want to change. Click in the DataType field to the immediate right of the field name. An arrow appears. Click on the arrow to produce a menu listing of datatypes. Select the one you want.
