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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Small Thick "Bar" Below Last Typed Line ? 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Tracking text changes 0
Mail Merge Directory Conditional Page Break 0
Determine if previous "character" is a section break 3
Modern equivalent of Autotext in Word? 0
Calculation Based on Dynamic Variables (What-if Scenario) 0

Top