Quote:
Originally Posted by Charles Kenyon
The term "text box" has multiple meanings. Is this part of a vba userform? An ActiveX control? A graphic textbox in the document?
Why does the protected form method not suit?
|
Sorry probably wasn't clear. I'm open to which ever type of text box has the ability to restrict word limits as opposed to character limits.
I have tried using the following:
- Text box - Insert tab then draw text box - Couldn't see how to restrict characters so assuming you cant restrict words.
- Rich text content control - Developer tab then Rich text content control - Couldn't see how to restrict characters so assuming you cant restrict words.
- Plain text content control - Developer tab then Plain text content control - Couldn't see how to restrict characters so assuming you cant restrict words.
- Text form field - Developer tab then Legacy tools then Legacy forms then Text form field - In properties I was able to set the type as Regular text then set the maximum length field to 1000, however this is 1000 characters not 1000 words. There is a Calculation type where an expression could be entered if anyone knows of one?
- Text box (Active X control) - Developer tab then Legacy tools then Active X controls then Text box (Active X control) - In properties I was able to set the MaxLength field to 1000, however this is 1000 characters not 1000 words. There is a VBA option for this box so assuming that there could be some code assigned to the box?
Protecting the document was good for allowing just editing the text boxes.
Hopefully that makes more sense?
