Dollars to text (1 Viewer)

[dlgates]

I have completed a rather basic payroll system for a client and am down to designing the check-writing part. I suddenly realize I cannot find any functions that convert dollar amounts to English text as required on a check (i.e., $150 is translated into "ONE HUNDRED FIFTY & 00/100"). I realize I could build a table and write some cumbersome code to do this on my own, but surely a ready-made solution must exist somewhere! Help!

 

[Rich]

Try here http://www.mvps.org/access/modules/mdl0001.htm
HTH

 

[dlgates]

Many thanks, Rich. That will save me a lot of time!