Converting numerical formats to text equivalent

[PaulA]

Hi, all--

Is there any way (that is not too complex) to convert a numerical value to the text equivalent for a report?

example: 125 would be converted to "one hundred and twenty-five"?

Thanks!

 

[Rich]

http://www.mvps.org/access/

 

[Lynnjm]

Please see Lynnjm 02-13-2002. I used the Alan Simpson method and it works brilliantly.