Change number to writing - MSAccess

[Eclairé]

How do I display a number in written format (to print checks) in Access?

i.e. $4,100.35
to Four thousand one hundred and 35/100 dollars

 

[Jeff Conrad]

See the following links for help on this:

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

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