convert numbers to text labels

[Sergio]

I would like to know how can I convert numbers to text labels. For example, in an invoice form, I need to print the total amount figure in both data types: number and text.

Tks in advance!

 

[DJN]

Dev Ashish has the answer. Follow the link.
http://www.mvps.org/access/modules/mdl0001.htm

David

 

[Sergio]

Thanks a lot for your valuable help. You save my life. I'm novice in VBA for Access and any help is very worthfull to me.

By the way, I'm from Queretaro, Mexico and my english isn't pretty well. So I want to thank you in spanish language: Muchas gracias amigo! Haz sido como un angel enviado del cielo. Espero encontrarte de nuevo.

Bye