How do i get access to type out numbers as text

gilsont · Dec 20, 2004

I would like to be able to punch in $20.00 and format the field to spell it
out as Twenty Dollars and 00 cents. Could someone help me out with this.

Rick B · Dec 20, 2004

Do a search

Asked allll the time

Bruce M. Thompson · Dec 20, 2004

I would like to be able to punch in $20.00 and format the field to spell it

out as Twenty Dollars and 00 cents. Could someone help me out with this.

See the following page at The Access Web:

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

....and the following page in the Microsoft Knowledge Base:

ACC2000: How to Convert Currency or Numbers into English Words
http://support.microsoft.com/?kbid=210586

gilsont · Dec 20, 2004

Thank You very much. I will now try to finish my project.

John Schmidt · Dec 21, 2004

Rick said:
Do a search

Asked allll the time

Check out the Access web at www.mvps.org for this. A function named
English will fill the bill.

John Schmidt · Dec 21, 2004

Rick said:
Do a search

Asked allll the time

Check out the Access web at www.mvps.org for this. A function named
English will fill the bill.