How to translate numbers to words

[CSCS]

Good day everyone!

I'm designing a system in which I have two fields
Amount in Numbers and Amount in Words

I want to be able to type in the amount in numbers and the amount in words should appear automatically.

I need the code and in wich event should I put it.

This is an urgent request. any help will be very much appreciated.

Thanks alot!

 

[sonny]

Like 123 = one hundred twenty three?

 

[sonny]

Try this link
http://www.mvps.org/access/modules/mdl0001.htm

 

[CSCS]

Thanks alot guys for the help.

but I'm really new in all this and I'm not that good in programming, so I didn't know how to alter the code to make fit my application.
I would be very greatful if any one can help me.
my two fields are
Amount in Numbers and Amount in Words

and can you please tell where to paste it.

your help is very appreciated.

Regards,
CS.

 

[CSCS]

I did exactly what you said, the problem is the code works perfectly in Visual Basic, but it fails to be called from the form field.
I wrote in the field's Control Source =English([Amount_in_Numbers])
yet all I get is "#Name?"

what could be the reason?