numbers to words

[chavez_sea]

I need to convert numbers to words in access to print on a check. Can someone help me , I dont know any codes.



Thanks

[pbaldy]

Here's a start:

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

[chavez_sea]

Thanks. However I need help. What do I do with the code. I assume I create a module, and insert all, but then what else do I need to do, eg in my query.

Thanks

[pbaldy]

Copy/paste the whole bit into a standard module, name the module anything but the names of either function. In a query you'd call it with:

NewFieldAlias: English(YourCurrencyFieldName)

[ajetrumpet]

Here's a start:

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

Wow! That's very helpful, Paul. That'd be easy to write, but I didn't even know there was code already written for that. Incredible...

[chavez_sea]

Payment Amount: English(Amount)

That is is the query. I get a pop up response " The expression contains ambiguous name. Verify that each name in the expression refers to a unique object.

Any help with this please.

[pbaldy]

What did you name the module?

[chavez_sea]

GREAT. What happen is that I had some other codes I was trying. I DELETED THEM. THis works great. IS there a way to have it omit the word exactly, but 00/100 or something like that as, it is for printing on a check, and or at least have the first letters in Cap.


Five hundred 00/00 Right now it shows up as


five hundred fifty and 05/100


five hundred fifty exactly

[chavez_sea]

THANKS> I got it to work. I changed the letters to CAPS in the code.


THIS WORKS GREAT!!!. SO grateful for your help.

[pbaldy]

You can customize the function to return anything you want. A good exercise would be to set a breakpoint and follow it through step by step so you understand how it works. Then you'll know how to customize it.

Adam: missed your post. I agree; this is one of many I would classify as not that difficult, but tedious to write.

[pbaldy]

Ah, obviously I was typing too slowly. Glad it helped you. Welcome to the site by the way!

[vivien]

Here's a start:

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

Everything ok except for the cents; .54 it appears 54/100

[pbaldy]

You can modify the function to return the cents any way you want.

[vivien]

You can modify the function to return the cents any way you want.

Actual I do not know how to write module, I only using access formula to create query. Can you help me on this?

[vivien]

Actually I do not know how to write function, I only using access formula to create query. Can you help me on this?