If you want to permanently change the text, take a look at using the replace field contents tool while using a calculaiton such as:
Let ( [ t = yourfieldHere ;
L = Length ( t )
If ( L < 241 ; t ; Left ( t ; Position ( t ; " " ; 240 ; - 1 ) ) & ", and more." )
I'm using the position tool to break off the existing text at the first space to the left of the 240th character to avoid having a partial word at the end of this text.
If you want to keep the original text unchanged, (I think this is a better idea). Use the above expression in a calculaition field set to return text. This would allow you to perform a find on the calculation field for "and more" and then you could inspect and adjust the wording of all descriptions that exceeded the limit.
That works PERFECT Phil. Thank you once again. I'll tell you, I'm keeping this website software company on their toes, they have had to make quite a few fixes and updates since I started working here finding little glitches in the system, and a simple max char count in their training literature and user guides to prevent someone from waisting company time going over it.
Just to let anyone else know that may look at this, I did have to drop the 240 in the calculation down to 229 to allow for the 11 chars of the ", and more".
Since I'm not an employee of FileMaker Inc, we're not wasting company time. Since I enjoy helping others, I don't see my time as wasted either.
There is a validation setting in field options you can add to limit input to a specified number of characters.