change property to currency

[samotek]

How can i change the property of a text to a currency ?
I am changing the property to number with the following line :
db.Execute "ALTER TABLE MyTable ALTER COLUMN F1 INTEGER", dbFailOnError

But i cannot change it to currency.The folloiwng line gives me an error:


db.Execute "ALTER TABLE MyTable ALTER COLUMN F2 dbcurrency", dbFailOnError

 

[Golom]

I think its

db.Execute "ALTER TABLE MyTable ALTER COLUMN F2 [COLOR=blue]Currency[/color]", dbFailOnError

"dbCurrency" is a VB environmental variable ... not the name of an Access DataType.

 

[PHV]

Another way:
db.Execute "ALTER TABLE MyTable ALTER COLUMN F2 MONEY", dbFailOnError

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886