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", "")
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)
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.
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) ------------------------------