change data field type in table

[jnewl]

have a make table query and even though, i specify one of the fields as
currency, the field type is number in the table. how i can i specify in vb
the field as currency after the table has been built? thanks for your help

 

[Allen Browne]

To programmatically change an existing Number field into a Currency field,
execute a DDL query:

Dim strSql As String
strSql = "ALTER TABLE MyTable ALTER COLUMN MyText2Change CURRENCY;"
DBEngine(0)(0).Execute strSql, dbFailOnError

Requires Access 2000 or later.

 

[Alex Dybenko]

hi,
after your table was created - you have to create a new field currency type
and then copy data from old field to a new one

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[jnewl]

thanks

 

[John W. Vinson]

have a make table query and even though, i specify one of the fields as
currency, the field type is number in the table. how i can i specify in vb
the field as currency after the table has been built? thanks for your help

Well... don't do a maketable query *at all*. They're very rarely necessary!

Create a table with the desired datatypes and run an Append query instead.

John W. Vinson [MVP]