Datatype conversion

J

Jay

I want to change number datatype to text datatype in quary design grid.
I used CStr(number) function. It did not work. Why not?
Text is a string datatype?
Any betteridea is appreciated.

hank you very much
 
R

Randy Harris

Jay said:
I want to change number datatype to text datatype in quary design grid.
I used CStr(number) function. It did not work. Why not?
Text is a string datatype?
Any betteridea is appreciated.

hank you very much
Click to expand...

What exactly do you mean by "It did not work"?
 
J

John Vinson

I want to change number datatype to text datatype in quary design grid.
I used CStr(number) function. It did not work. Why not?
Text is a string datatype?
Any betteridea is appreciated.

hank you very much
Click to expand...

If you're expecting Cstr(3125) to return "Three thousand one hundred
twenty five" you'll be disappointed. It returns the text string
"3125".

John W. Vinson[MVP]
 
Top