Displaying monetry amount as written text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Happy Holidays,
Does anyone know of, or know where I could obtain, vba code to display a monetry amount as written text. Something similar to writing a check out. When an amount of '$500' is entered it would display elsewhere on a form as a written amount of 'Five Hundred Dollars'. I think I saw something similar to this a couple of years ago, but do not know where I saw it.
Thank you in advance for any assistance, Pedro
 
Pedro,

Start at: http://support.microsoft.com
Choose Search the Knowledge Base
Search terms: Currency English

Search results include:

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

ACC2000: How to Convert Currency or Numbers to English Words in a Data Access Page
http://support.microsoft.com/?id=234302

ACC: How to Convert Currency or Numbers into English Words (Version 1-->97)
http://support.microsoft.com/?id=95640


Tom
_______________________________


Happy Holidays,
Does anyone know of, or know where I could obtain, vba code to display a monetry amount as
written text. Something similar to writing a check out. When an amount of '$500' is
entered it would display elsewhere on a form as a written amount of 'Five Hundred
Dollars'. I think I saw something similar to this a couple of years ago, but do not know
where I saw it.
Thank you in advance for any assistance, Pedro
 
There is code available at The Access Web which will do that for you:

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

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Pedro said:
Happy Holidays,
Does anyone know of, or know where I could obtain, vba code to display a
Click to expand...
monetry amount as written text. Something similar to writing a check out.
When an amount of '$500' is entered it would display elsewhere on a form as
a written amount of 'Five Hundred Dollars'. I think I saw something similar
to this a couple of years ago, but do not know where I saw it.
 
Back
Top