Data type conversion - text to number & number to text.

[connexion]

HiThere,

I was going to go into detail about why (but i don't have FOREVER to type it all...lets just ask the question instead...

Is there any specific function able to convert a number stored as a text data type back to a number data type?

OR
Might it be possible to create a function using select case to move along a number stored as a text string, character by character, looking up their ascii value to build the same string as a number?

Just thought i'd ask before attempting to create it in case i'm wasting my time.

Thanks
Vince

 

[richary]

Use the Val() function or search help for Type Conversion Functions.

Richard

 

[DB7]

As Richard said. ... More specifically CInt(), CStr()
Do veer away from using AScii to determine data types. Won't work, and may give deceiving results.