Function to convert data

[Jack]

Is there a function in access to convert a number like " 1234.56 " to a
string like " one thousand two hundred thirty four and 56/100 dollars "

 

[Dirk Goldgar]

Is there a function in access to convert a number like " 1234.56 " to a
string like " one thousand two hundred thirty four and 56/100 dollars "

Not built in, but several user-written functions have been posted. Here's
one, written by Joe Foster:

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

 

[Ken Snell]

No. However, there are examples of functions that will do this for you on
the internet.

Here's one:
http://www.mvps.org/access/modules/mdl0001.htm