How do I convert a numerical value into its written form?

[e-man]

I would like to convert a number entered into an access form or table in
numerical format into its written form (i.e. 2142 converted to "two thousand
one hundred and forty two")

 

[Ofer]

See the Access Web:

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