number - alphabetical string

[Florin]

Where can I find a function to transform number in alphabetical string ?


Thanks

 

[Allen Browne]

Where can I find a function to transform number in alphabetical string?

Is this what you are looking for:
Convert Currency ($500) into words (Five Hundred Dollars)
at:
http://www.mvps.org/access/modules/mdl0001.htm

 

[John W. Vinson]

Where can I find a function to transform number in alphabetical string ?

What sort of conversion? Do you want to transform the number 6 to the
alphabetical string "6" (CStr will do that for you), or the number 65 to the
letter "A" - its ASCII equivalent (Chr() is the function for this? Or do you
want to transform the number 6 to the text string "Six"?

 

[Florin]

Thanks,

I want to transform the number 6 to the text string "six"

 

[John W. Vinson]

Thanks,

I want to transform the number 6 to the text string "six"

You will need some VBA code. You should be able to adapt the code here:

http://www.mvps.org/access/modules/mdl0001.htm

It uses Currency rather than Number fields but the logic will be exactly the
same.