Numbers to words

[Nigel Grice]

I need to convert numbers input in a currency field into words in a text
field

ie input into a currency field [Amount] $1,123.00

automatically puts into a text field [Amount in words] "One thousand one
hundred and twenty three dollars and zero cents".

I can do this in Visual FoxPro but how do I do it in Access?

Regards

Nigel

 

[Cheryl Fischer]

Access can do that, too! There is code at the following link that you can
use:

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

hth,

 

[Byron]

You might take a look at the following location and
document:
http://www.mvps.org/access/modules/mdl0001.htm

This article should help.

Byron