You could move the WordNum function to the calculate event of the text field (might be a better place for it anyway).
So you would have something like;
----- form1.#subform.DollarAmountText::calculate: - (FormCalc, client) ------------------------------
I see what you mean, very annoying. I can only guess you could try something really hacky like;
), "Dollars ",""), "Dollar ",""), "Cents", ""), "Cent", "")
Using the WordNum formcalc function, how can i get the output without the "Dollars" and "cents"?
FormCalc has a WordNum function that will do this. So maybe on the exit event of the dollar amount field you could have;
= WordNum($ , 2)
Where DollarAmountText is the field to show the text equivalent. "$" is FormCalc's way of referring to the current field and "2" means monetary value with cents.
But the value come Different :One Hundred Thousand only.(I think this is Us Relevant,but I don't need this.i want India Format)
I wrote code in Formcalc:
then try WordNum(amount)
Can I add prefix and suffix to the converted text?
eg. "SAY US ONE HUNDRED SIXTY THOUSAND DOLLARS AND SIXTY FIVE CENTS ONLY."
Can I make the converted text auto upper case?
thanks man. the replace works great. i dont mind being hacky .
Yes, but this will not also print in words any figure after the decimal. i.e. Amount = 1.25, with wordmum(Amount), the output is One. i want it to print One and Twenty Five as it should.
with wordnum(amount, argument), i get "dollars" and "cents" in the output. can i get the output without "dollars" and "cents" as part of the output.
thanks in advance.
Just leave of the second argument, that is just use WordNum(NumericField2)
Thanks very much for your help Bruce that's done it!!
Thanks for the help, I can see how that FormCalc script works on exiting a field where the dollor number has been entered but what do I need to add to it in a field where the amount has been simply carried forward from a calculated field. Currently in this number field is:
----- form1.#subform.DollarAmount::calculate: - (FormCalc, client) ------------------------------