Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Dallas, Texas, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Display numbers as text (Access 97)

    I was wondering if anyone could help me or point me to a good resource. I have a finance database I have created and want to have it print checks but I am not sure how to make the currency amount such as $10.00 appear as Ten and No/100 Dollars. If anyone could help me find a good resource or tell me how to go about it, I would greatly appreciate it. Thanks in advance,

    -Ronnie =)

  2. #2
    New Lounger
    Join Date
    Apr 2002
    Location
    Dallas, Texas, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display numbers as text (Access 97)

    Hans,

    Thanks for your help. I will look up that article and put it to use. Thanks again! =)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Display numbers as text (Access 97)

    In <!mskb=95640>Microsoft Knowledge Base Article 95640<!/mskb>, you will find a Visual Basic function ConvertCurrencyToEnglish that does not do exactly what you want, but comes very near. You should be able to adapt it to your needs. The article also contains a link to download a sample database in which the function has been implemented.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •