Num to Words

[rajeevraj]

Hi all,

I am looking for a macro or vb code for converting a numeric value in
one field to words and storing the same in other field.

eg field "Chgs" 100/-
to be converted into words One Hundred and stored in field "Amount"

Thanks in advance

Rajeev

 

[Jeff Boyce]

Rajeev

I seem to recall seeing a "numbers-to-words" routine at the mvps.org/access
website.

By the way, if you already have the numbers stored, you really don't need to
also store the text. I'll guess that you are preparing to print something.
Use a query in which you call the function that turns numbers to words, then
use the query as the source for your report.

Or maybe I'm reading too much into your post...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[scubadiver]

This may help

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