Currency format

B

Beth

Is there a set format in Access to spell out currency, like you would do on
the second line of a check? If not, does anyone have a formula they can
share that will accomplish this task?

Thanks in advance,
Beth
 
D

Dirk Goldgar

Beth said:
Is there a set format in Access to spell out currency, like you would
do on the second line of a check? If not, does anyone have a formula
they can share that will accomplish this task?
Click to expand...

There's nothing built-in, but you can get a function to do it here:

http://www.mvps.org/access/modules/mdl0001.htm
Modules: Convert Currency ($500) into words (Five Hundred Dollars)
 
Top