Text Field Limitation

In a single document. Text Field can have 32k Data Thats is a known factor. But Alltogether ( Overall Text Fields size) I am not able to put more than 64k data.

For Example in a Form is having 4 Fields

Field 1 =>20K of data

Field 2 =>20K of data

Field 3 =>20K of data

Field 4 =>20K of data

I am not able to put 20k in “Field4”. Only I can put 3.5k data in the “Field4”

Per Document overall size of text Field is 64k only its allowing its not allowing more than that. If I try to put more than that I am getting this error.

“Field is too large (32k) or View’s coloumn & selection formulas are too large”

What could be the solution?

Thanks in Advance

Anto

Subject: Text Field Limitation

The solution is to put less data in summary fields. Can you either use a rich text field, or use LotusScript to change the multivalue items’ isSummary property?

Subject: RE: Text Field Limitation

IsSummary property is set to True only for that field.But my question is Query 2 is giving the actual count but why Query 1 is not giving the actual count ??

Query 1)

([DOCNUMBER] contains (ZA*))

Query 2)

([DOCNUMBER] contains (ZA00*))

OR ([DOCNUMBER] contains (ZA01*))

OR ([DOCNUMBER] contains (ZA02*))

OR ([DOCNUMBER] contains (ZA03*))

OR ([DOCNUMBER] contains (ZA04*))

OR ([DOCNUMBER] contains (ZA05*))