Convert Numbers to Text

[angshubh]

numeric to text conversion, amount value

I have stored payments amounts like 1875.00 in a column. Now in my report i want to show them as 'One thousand eight hundred seventy five'. How best I can do that?

 

[Mile-O]

The Access Web provides this.

Also, please don't double post. One forum (the correct one preferably) will suffice. I deleted your other post.

 

[angshubh]

Thanks for the help. I got the cod, but how to use this? I tried writing a module but it didn't work out. Can u tell me some easier way?

Also, actually i posted the question in queries by mistake. My apologies.

 

[Mile-O]

• Copy the code on that site into a new module.
• On your report add a new textbox
• Set the new textbox's ControlSource to: =English([txtCurrency]) where txtCurrency is the name of your textbox to convert
• That's it.

 

[angshubh]

Thank you very much! It worked perfectly. Great help!!