SHOW NUMBERS IN WORDS

[Guest]

Is there any way for me to convert numbers to text......

I mean, for example, I have a form with two textboxes, I put 181, in one
textbox, and I would like the other textbox to show One Hundred and eighty
one..... is there any way to do this???

 

[Wayne Morgan]

Here is an example doing this with currency, you should be able to modify it
for other numbers.

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

It shouldn't turn out the way you have it, technically "one hundred AND
eighty one" would be 1.81. 181 would be "one hundred eighty-one".

 

[Arvin Meyer]

Is there any way for me to convert numbers to text......

I mean, for example, I have a form with two textboxes, I put 181, in one
textbox, and I would like the other textbox to show One Hundred and eighty
one..... is there any way to do this???

How about something like this:

http://www.mvps.org/access/modules/mdl0001.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access