Figure to words - Not able to get proper answer

[Guest]

Can any one tell in Acess Program
What is the formula to be written for automatically changing from figure to
words.
ie., for example,In Form
if i will write in one column Rs.2000/-
can other column be updated automatically Rs. Two Thousnad

from previous answer i could not able to do it because that was coding & i
cant do coding in access. Would u pl. explain me in depth.
Thanks & regards,
SAJAN

 

[ruralguy via AccessMonster.com]

Maybe this link will help.
http://www.mvps.org/access/modules/mdl0001.htm

 

[Linq Adams via AccessMonster.com]

If you want to do this you're going to have to do it with VBA code. The link
below actually uses the same code listed on the link that RuralGuy gave you,
although the function name is different and the code is credited to a screen
name of M8KWR, rather than Joe Foster. This link, however, gives you as
simple a set of step-by-step intructions for using the code as you're going
to find anywhere.

http://www.thescripts.com/forum/thread625202.html

Good Luck

Linq

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com