Re: [MS_AccessPros] Access 2010 =NumWord Expression

 

hello (what is your name?)

Welcome.

What is the VBA for the NumWord function?

To find that out, you can right- click on 'NumWord' in your code and choose "Definition" from the shortcut menu

~crystal

free Tools for Microsoft Access
http://msaccessgurus.com/tools.htm

On 11/4/2018 2:02 PM, mtamiazzo@gmail.com [MS_Access_Professionals] wrote:

Hello,

 

I'm using the Access 2010 and my NumWord expression worked fine until I started using numbers in the millions.

 

The expression is"

 

=NumWord([Contract Amount]) & "   ******************************"

 

$494,725.00 in the Contract Amount field returns:

Four Hundred Ninety Four Thousand Seven Hundred Twenty Five and 00/100 ******************************

 

$1,175,442.00 in the Contract Amount field returns:

One Hundred Seventeen Thousand Five Hundred Forty Four and .0/100 ******************************

 

Does anyone know why?

 

Thank you.

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___