Let me share you these simple tips on how to create an ms access visual basic function that will convert numbers into words (up to billions). This function is very useful if you want a converted amount in words to appear on your voucher, checks, payslips, payroll summary report, just to name a few.
I created this function myself and I can guarantee you that it is 100% functional in ms access 2003 (i am not sure with other versions of ms access but I think it will work the same). With this very simple function, I was able to meet the needs of my clients in terms of numbers to words conversion requirement -- they were all satisfied with the result.
The function is very easy to use. Simply copy the function and then paste it in one of your modules in ms access. Now you can call this function anywhere from your ms access application (reports, forms, queries, etc).
Please try it by following these 3 simple steps:
Step #1: Copy my ms access visual basic function below and insert it into your ms access module.
I created this function myself and I can guarantee you that it is 100% functional in ms access 2003 (i am not sure with other versions of ms access but I think it will work the same). With this very simple function, I was able to meet the needs of my clients in terms of numbers to words conversion requirement -- they were all satisfied with the result.
The function is very easy to use. Simply copy the function and then paste it in one of your modules in ms access. Now you can call this function anywhere from your ms access application (reports, forms, queries, etc).
Please try it by following these 3 simple steps:
Step #1: Copy my ms access visual basic function below and insert it into your ms access module.
Step #2: create a form in ms access with two text fields on it. Name the first text field as txtNumber and the other text field as txtInwords. Change the caption of txtNumber with Number and txtInwords with In Words
Step #3: Set the AfterUpdate Event of the txtNumber text box with this visual basic command: Me.txtInwords = convert(me.txtNumber).
You may now run your form and try.
The sample visual basic codes can include trillions please let me know i will include it for you. You can email me at mfirebux@gmail.com.
If you have anything about to say about this sample ms access visual basic function please let me know -- just leave your comment here.
How about number to word conversion using Indian Numeral System? Contact me should you need this kind of conversion in MS Access.
