Calculation to count lines of text? Hidden text cut to a new field?
Is there a way to have a calculation field count the number of lines in a text field?
I have a form, and people fill out the form but the text is more then the field allows. So some of the text is hidden. I want to have the hidden text appear in a different field at the end of the document. I have a script to count number of letters and cut text left and right and paste into that field at the end of the document but each letter seems to be a different size (i.e. certain combination of words 85 in length might fit on one line before wrapping, but then some letters 85 in length might be jsut fine). Wonder if there is a way to count returns or lines or wraps of text?
Thanks I am loving the new File maker 11 much better then 9!