Converting currency to string

[Nick Smith]

I would like to write a function to return the textual value of a numerical
currency field on a form.
For example, the user would enter the value 23156.04 in a field and the
function would populate another textbox with the text: "Twenty three
thousand, one hundred and fifty six dollars and four cents" or similar.
Does anyone know where I could find a code snippet to do this? Thanks

 

[Ron Weiner]

Here is one way.

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


Here is another

http://www.ozgrid.com/VBA/CurrencyToWords.htm


Ron W.

 

[Nick Smith]

Thanks Ron, that's brilliant!

Here is one way.

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


Here is another

http://www.ozgrid.com/VBA/CurrencyToWords.htm


Ron W.