Convert Currency into words

[jaguar2006]

Hi everyone,
I need help with access 2003
I want to convert Currency (like 500 $) into words (Five Hundred Dollars) on my reports or forms.
I have code for it from http://www.mvps.org/access/modules/mdl0001.htm but I do not know how I can use it.
Thanks

 

[midmented]

module

Here are the basics.

Make a new module and paste the code into it. When you want to convert the number to text simply call the module from your form like $5.50.
I'll use a msgbox to get the string..

msgbox(English(5.50))

For a report textbox, the control source would be like
=English([CurrencyFieldname])

If at first you don't succeed, you must be a programmer.