[AccessD] Set a field data type via code

Thank you, Mark.  I must have used the wrong words in my archive search.  I 
think the solution offered in Van's post is the way I'll have to go.

Gina

-----Original Message-----
From: Mitsules, Mark [mailto:Mark.Mitsules at ngc.com]
Sent: Tuesday, October 21, 2003 3:27 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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)
-----------------------------------------

_________________________________________________________________
Add MSN 8 Internet Software to your current Internet access and enjoy 
patented spam control and more.  Get two months FREE!     
http://join.msn.com/?page=dept/byoa