Changing Field Type

C

Chris Gorham

Hi,

I'm trying to change the field type in a table from text to number using VBA
code.
Any help is much appreciated...Rgds Chris
 
S

Steve Schapel

Chris,

You can make a query like this...
ALTER TABLE MyTable ALTER COLUMN MyField DOUBLE

You can then use VBA to run this query, for example...
CurrentDb.Execute "ALTER TABLE MyTable ALTER COLUMN MyField DOUBLE"
 
Top