June 28, 200223 yr 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?
June 28, 200223 yr 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.
June 28, 200223 yr Author 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?
June 28, 200223 yr In that case, here's a simple version: Two fields: Number (number) Num_to_Word (unstored, text) = Choose (Number, "Zero", "One", "Two", "Three", "Four")
Create an account or sign in to comment