[AccessD] Set a field data type via code

Based on our work on the Back End Upgrader, in order to change a data type
thru code you will need to create a new field, move the data to the new
field, delete the original field, and rename the new field.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark
> 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)
> -----------------------------------------
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>