Convert data type from text into number

[mypeljo]

In the design view of my table called "products" i can convert easily the data type form text into code. I need however to convert it through code in order to automate the function.Can you help me with the solution, how can i convert the data type of the field " code" to be number instead of text?

[LarryEngles]

Look up "Type Conversions functions" in help. You'll find cint (for converting to integers), cdbl (for converting to doubles), etc.

[mypeljo]

Thank you !