I want to limited the number of words in a text field to 100. Can this be done?

define fields-> field validation->calculation->

length(myfield)<=100

Hi,

Christian I think you missed something on the post - thats very unlike you!! You are normally a God! You must be working too hard on your transparant images!

Mamawong50, that suggestion will limit the field to 100 characters, to limit it to 100 words use this:

WordCount(myfield) <= 100

Ed.

>You must be working too hard on your transparant images!

Not really. I just may have trouble reading my PowerBooks screen in bright sunlight, my vision degrading further by a having a glas of beer next to the keyboard ...

OK, but with words I would rather choose a different aproach in addition to the field validation:

make an unstored calc, WordCount(myfield) & put it in the header. This let's users see the actual word count, so they can choose their wording according to the remaining # of words. Nothing is more annoying than to be forced to reformulate sentences just because word limit is reached in the middle of the text.

Maybe even add a warning field if 85 words are reached:

If(WordCount(myfield) >85, "Come to an End. No Novels here!!!";"")

Hi Christian,

You are too kind to your users, personally I like to see them hit the 100 word Brick Wall, get angry as hell trying to figure out what happen, and then hopefully they end up tossing there sunglasses one way and their ******* PowerBook's another way, thereby knocking over their ******* beer bottle or mug, stein, or whatever, and then...................... Just kidding,

I like the warning idea.

Lee