[AccessD] Set a field data type via code

> Is it possible to use code (cbf) to change a field's data type, in the
table itself, from number to text?



I found this post...hope it helps (and is correct...).


Mark

-----------------------------------------
From: Van T. Dinh     
Date: 08-07-03 15:01
Subject: Re: Access field.type change    
-----------------------------------------
IIRC, even when you change the Field Type through the GUI, Access / Jet
actually creates a new Field, updates the new Field with converted values
from the old Field, delete old Field and then re-name the new Field to the
old name.

Thus if you want to change the Field Type by code, you will have to follow
the same process.

--
HTH
Van T. Dinh
MVP (Access)
-----------------------------------------