number in words

[varunmathur]

I am using Access 2000. And am making a database to acct for pay and allowances of employees, I need to place the total pay in words in a text box/label in a report.I have written a VBA code which i think should work but I dont know how to make it read the value of a running sum in a report and the output the amt in words in a text box.The code is currently placed as a separate module.
Any help will be greatly appreciated .
varun

 

[varunmathur]

Thanks Pat,
It works now.
But unfortunately the code is'nt too good and it reads some numbers correctly and does'nt some numbers.
Anyway thanks
Varun

 

[llkhoutx]

A running sum should be treated no differently than an individual number. Be sure that your running sum is calculating correctly.

 

[varunmathur]

Thanks Pat and Illhoutx,
The codes been a great help. but now a wird problem has arisen:- The running sums and the number in words are correct in the preview mode of the report. but on printing the report the fields are blank or show the value as 00.00.
Any Idea why this could be happening,could it be I have overloaded the report footer with VBA.
Varun