Changing Field Type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
Back
Top