CODEWITHSUNDEEP
ms-accessms-access-2007
jinsungy
jinsungy

Reputation: 10845

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

How do I specify Max Length for TextBox on a Form?

Upvotes: 2

Views: 19033

Answers (2)

LM358
LM358

Reputation: 141

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!"

Upvotes: 2

Kevin Ross
Kevin Ross

Reputation: 7215

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

Upvotes: 6

Related Questions