What is the max size of the multi line text field? Can I set it?
A Multiple lines of text column can store up to 63,999 characters, and you can specify the number of lines of text that you want to display when people enter information about an item. This type of column displays all the text when the column is viewed in a list or library.
According to my research, the Hyperlink column in a SharePoint list or library have a 255 character limit. You can create a Multi-lines of Text column to solve this problem.
Column limits Each column type has a size value listed in bytes. The sum of all columns in a SharePoint list cannot exceed 8,000 bytes.
A multline text input field stores a string as its value and a string as its text. Its value is always a valid string, while its text could be any string entered into its editor. Unlike a text input field, this field also supports newline characters entered in the editor.
A multi line text field is Defined in sharepoint as a 'Note' type, this is stored in the the DB as a ntext sql type.
In the SQL type can store 2gb of char data, that's 1,073,741,823 characters.
Obviously there are practical limits on how big this data should be allowed to get - as SP is a web based system, you do not want to be passing 2gb back and forth all the time.
You can't set it, but you could use a workflow to check the size of the data in the fields and ether truncate or warn about the size of the field.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With