Limit Text Field Length - Text Length Override

User is using a column "PROTOCOL_NAME" (varchar-100) to store the value entered in the Field "Name"(varchar-30) but can enter more than 30 characters.

It seems intuitive that a field attribute called "Text Length" would set a limit to the amount of text that could be entered into a field. But the fact is that the amount of text that a field will accept is normally determined by the size of the underlying database column and the text length property is ignored.

 

This can be achieved by the following ways-
1. Find a database column that has the exact number of characters you need.
2. Use a field validation that will popup an error message if a user enters more characters than required.
3. Scripting can be used to alert the user and do not allow to save the record if the number of characters exceed a specific limit.

 

An ideal solution for the problem would be the use of a Field User Property "Text Length Override"

 

This user property allows you to specify that the text length of the field, rather than that of the database column, defines the maximum field length.

 

 

 

Field User Property:

Name - Text Length Override
Value – TRUE

 

The value TRUE makes use of the length specified at the Text Length Property of the Field and overrides the one at the database level.

 

 

Note:Use this for Text Fields