NumToText

[KLA]

ok... I have a number field on one layout and i want it to display as a text on another layout. I need it to be a number field on the first layout so i can't change the field to text. So, i created another field that is a calculation field and used the NumToText and checked the caluc. result as Text. But, it doens't work. It still shows as a number. What am i missing?

[The Bridge]

I presume you want to convert numbers to words, e.g. 1 = "one", 100="one hundred", etc.

In which case you can find your answer here.

[KLA]

Thanks Peter - but that was WAY too complicated for me to follow. The only numbers that will be in my number field are 1,2,3, or 4 and i want it to say in the new field - One, Two, Three, or Four. That's it. VERY simple. No huge numbers or caluclations or money involved. Any other suggestions?

[The Bridge]

In that case, here's a simple version:

Two fields:

Number (number)

Num_to_Word (unstored, text) = Choose (Number, "Zero", "One", "Two", "Three", "Four")