How do I format currency to display text

D

Drew

I'm creating a report in Access 2003 (as part of an accounting database) that
prints checks and I am trying to figure out how to display a currency as a
text. In example: $100.00 = one hundred.

I have to type the text as of right now but I print out approx. 2000 checks
at a time and this takes too long. Anyone have any suggestions?
 
J

Jeff Conrad

in message
I'm creating a report in Access 2003 (as part of an accounting database) that
prints checks and I am trying to figure out how to display a currency as a
text. In example: $100.00 = one hundred.

I have to type the text as of right now but I print out approx. 2000 checks
at a time and this takes too long. Anyone have any suggestions?
Click to expand...

In addition to the link Brendan provided, here is some additional
information on this subject.

How to Convert Currency or Numbers into English Words:

http://support.microsoft.com/?id=210586

And one more link for fun:

http://www.vbexplorer.com/VBExplorer/tips/src36.asp

Good luck with your project,
 
Top