How do i get access to type out numbers as text

[Guest]

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]

Do a search

Asked allll the time

 

[Bruce M. Thompson]

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

 

[Guest]

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

 

[John Schmidt]

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]

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.