Amount in words

[Guest]

Hi

Is there anyway I can convert an amount in figures to words. As soon as the user enters amount in figures in the textfield "txt_amt" the amount should be converted in to words in the textfield "txt_words". Is it possible to perform such an activity?

 

[Cheryl Fischer]

You'll find a very nice function to convert a numeric amount to English text
at The Access Web:

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



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

Hi,

Is there anyway I can convert an amount in figures to words. As soon as

the user enters amount in figures in the textfield "txt_amt" the amount
should be converted in to words in the textfield "txt_words". Is it possible
to perform such an activity?

 

[Guest]

Thanks for the help, but how do I use this function in my application

Sahil

 

[Cheryl Fischer]

In the AfterUpdate event of your control "txt_Amt", insert the following:

Me!txt_words = English(Me!txt_Amt)

 

[Guest]

Thanks for the help. This is just great!!!!