Raymond P McIntosh 5.Aug.11 10:09 PM a Web browser Approach 9.7 Windows 7
This is mostly a curiosity question, since I've solved the problem, but does anyone know if there is a length limit on the formula for a calculated field?
I have a fairly long formual (mostly because it has some fairly lengthy constants). In working my way through the formula, it evaluated correctly within the formula box (that is, the red X through the flag disappeared). However, when I clicked the OK, I got a message that the formula could not be evaluated, and asked me to enter a vaild formula.
I solved this by creating three calculated fields, each of which contained a portion of the long formula, and then made a fourth field that just keyed on the three "subfields." This worked.
But being curious, I then played around with the original formula--entering a portion of it, then trying it. Then I'd add a bit more, and try it again. I kept doing this until eventually about two thirds of the way through the formula, even though the little flag in the formula box was clean, I would get the "Cannot Evaluate" message.
My tentative conclusion is that there must be a limit to the size of a formula, either in characters, or in operators, or something, so that even if the logic is good, Approach just can't handle it.
Does anyone know if this is true, what the limit is, and where I can find whatever other such limits exist?