Displaying NUMBERS as WORDS (like on a cheque)

[Gary]

Hi, I really need to know if access has any function to convert numbers into
text.

I have a report to print a cheque which works great but before I can print
the cheque I have had to make a form to enter the amount in words. Its
really anoying and I would like a function to be able to enter an amount as
a number then for it to be converted into words automatially.

Any ideas anyone?

Gary
(e-mail address removed)

 

[Cheryl Fischer]

There is code at this link that will do exactly what you want:

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