displaying letter version of a number

[northernbeaver]

I have a quick program to record payroll information and print the cheques, is there a way to convert or display a number as text (say $1245 displayed as "one thousand, two hundred forty five"?)

 

[dhookom]

There is a function that you can use at

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

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CautionMP]

Just because it's part of Tek-Tips...
How to Get the String Representation of a Numerice Value (Check Writer) : faq181-1740

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT+08:00) Singapore