MS Access 2007: Specify Max Length for TextBox on a Form

How do I specify Max Length for TextBox on开发者_Go百科 a Form?

This should help you on your way

http://allenbrowne.com/ser-34.html

It covers if users paste into the box and lots of other ways making it very useful

You can use validation rules. Open the Property Sheet of the Form -> Tab 'Data' and fill out 'validation rule' with e.g.: Len([fieldname])<=42 Or Is Null

You can also add a 'validation text' like: "Maximum 42 chars allowed!"