Display number value in words

[Eusebius]

Is there a function that will convert a number/currency value to written-out text? I'm creating a report to print checks & need to write out the amount in words, i.e. 142.53 as "One hundred forty two and 53 / 100 Dollars".

Thanks!

Matt

 

[pcs]

check these out:
http://www.access-programmers.co.uk/ubb/Forum5/HTML/001648.html
http://www.access-programmers.co.uk/ubb/Forum5/HTML/000182.html

hth,
al

 

[Eusebius]

Thanks Al! Seems to work great.