Custom Currency Format

[Colleen]

I used to use Alpha 5 which was able to apply format that
converted my curreny to a long written format. I have
created a check writer in Access and need to
automatically enter a dollar amount and have it formated
in the long written format
EX: $25.13 to
Twenty-Five Dollars and 13/100.
Does anyone have an answer for this one?

 

[Cheryl Fischer]

There is code at:

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

that will convert your currency values to their English equivalent.