$150 to be automatically write as "one hundred fifty" in MS Access

[Guest]

In MS Access, I design a report which show total of a field in Value (i.e.
in number) and the same is to be write in word. For example - $150 to be
automatically write as "one hundred fifty" in MS Access. Please which MS
Access
function to be used.

 

[fredg]

In MS Access, I design a report which show total of a field in Value (i.e.
in number) and the same is to be write in word. For example - $150 to be
automatically write as "one hundred fifty" in MS Access. Please which MS
Access
function to be used.

See:

Modules: Convert Currency ($500) into words (Five Hundred Dollars)

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