Printing Checks, Need to convert numbers to text 1

[MagnusFox]

I pass my form the numeric field [Total]. I need to print out the words that represent that field in a separate field.

Example:
[Total] = 1234

Filed1 would display "1234"
Field2 would display "One Thousand Two Hundred Thirty Four"
so my question is how do I get 1234 to display as One Thousand Two Hundred Thirty Four?

Thanks much,
Magnus

 

[JoeMiller]

Check out this web page, it does what you want:

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

Joe Miller
joe.miller@flotech.net