In addition to Phil's contribution, here are some other methods that you can use:
Convert Currency ($500) into words (Five Hundred Dollars) by Joe Foster
http://www.mvps.org/access/modules/mdl0001.htm
and
How to Convert Currency or Numbers into English Words (Microsoft KB article)
http://support.microsoft.com/?id=210586
Also, see related KB articles # 234302 (for DAP's) and 95640 (for Access versions 1-->7).
Note that for either of these methods, you do not want to include commas in the number. For
example, from the Immediate window, the commands:
? English(2,500,500.23) or ? ConvertCurrencyToEnglish(2,500,500.23)
will produce a run-time error: "Wrong number of arguments or invalid property assignment",
whereas the commands:
? English(2500500.23) or ? ConvertCurrencyToEnglish(2500500.23)
will return the results:
"two million five hundred thousand five hundred and 23/100" and
"Two Million Five Hundred Thousand Five Hundred Dollars And Twenty Three Cents", respectively.
Tom
_________________________________
I would like to change numbers from numerals (ie 258) to
words (Two Hundred Fifty-Eight.)
I would prefer to do this with Access, but would be
satisfied in Excel.
Thanks for any help.
Jeff
