Change field data type from number to text 1

[surfbum3000]

I need to change the field data type in a table from number to text.

 

[surfbum3000]

Use the following code in the SQL section of the query to change the ID field in the table tblName from number to text:

ALTER TABLE tblName
ALTER COLUMN ID text

 

[JerryKlmns]

From the help of Access VBA

The Microsoft Jet database engine does not support the use of ALTER TABLE, or any of the data definition language (DDL) statements, with non-Microsoft Jet databases


I would open the table and change the field type by selecting the Text data type!(save the change)

If it is VBA then...
CurrentDB.Execute "ALTER TABLE tblName ALTER COLUMN YourField CHAR"

or (MS-Access 2000+)

CurrentProject.Connection.Execute "ALTER TABLE tblName ALTER COLUMN YourField CHAR"