I have a form that has a dialog list defining the document type. The form also has a section that contains a computed subform, based on the document type selected. (Obviously the "correct" subform won't display until the document has been saved, closed, and reopened.)
The subform contains a series of checklists, each within its own collapsed section. Each checklist is broken into sub-parts, with each sub-part on a tab of a tabbed table. Each sub-part will have between one and a dozen or so (sometimes -- rarely -- more than that) questions. Each question is a line in a table inside that tab, with three columns in it. The first column is a dialog list of Complete/Not Complete/Not Applicable. The second is a computed-when-composed text of the question (done this way so when they want me to change the question text, it doesn't affect previous checklists) being checked. The third column is a field that says who changed the first column, and a second (hidden) field that tracks the history of who changed the column when.
Screen shots of this in the client and the developer are available here (for a limited time?), for clarity: http://www.pointcontrol.com/EE/checklist.gif
I've been doing the checklists this way for more than a year without problem. Recently they had me add four new checklists to one particular subform that previously had two checklists on it. (We're all about process these days -- having them, at least.) One new checklist has 105 questions spread (unevenly) across 17 tabs. Other checklists have as few as 17 questions.
After I put in the checklists I started getting "Notes error: Field is too large (32K) or View's column & selection formulas are too large" when the document went into edit mode. I figured the 105-question checklist with as many as 23 questions on a tab must have overdone it. But when I deleted that section from the subform, I still got the error. So I started deleting other sections/checklists from the subform until the error went away.
Then I restored a copy of the subform with all sections/checklists intact, and deleted only the last checklist I had deleted before to make the error go away. The error went away.
So the 105-question checklist with 23 questions on one tab didn't cause the error. The 29-question checklist with no more than 6 questions on any one tab caused the error.
I've gone back over every field in the problematic checklist (the fifth of six checklists on the subform) to verify field definitions and such, to no avail. Any suggestions here on what I might be missing?
This is all in R5, by the way. The users are on 5.0.8 or 5.0.10, and the database is accessed only in the client.