How to fix the size limitation on Lotus Notes summary text fields

• For Lotus Notes 6.x and Lotus Notes 7.x, the limitation is 32K per field and allows approximately 61K (64K minus the overhead) of summary information per document.

• For Lotus Notes 4.x and Lotus Notes 5.x, the limitation is 15K per field and allows approximately 61K (64K minus the overhead) of summary information per document.

For further explanation, check out the IBM support article Error: 'Field is too large (32k) or view's column and selection formulas too large' when saving document.

More resources on size limitations and LotusScript: LotusScript Learning Guide LotusScript FAQs Lotus Notes item/field size limitation LotusScript Reference Center

This can lead to a Lotus Notes field or document having more data than can be displayed in a summary, which in turn prevents a Lotus Notes document from being edited and saved by users.

There are two LotusScript procedures to help resolve this problem, which I've provided in this code. The first will report field sizes and the second will fix the IsSummary flag for all fields above the threshold.

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Brent Quick. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Rate this Tip To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member. Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT LotusScript LotusScript equivalent of @Picklist for Lotus Notes Launch large attachments within an email from a Notes database How to find files on a hard drive or mapped network with LotusScript Update the ACL from the Roles view with LotusScript LotusScript agent moves tagged spam email to junk mail folder Set a value in a field existing in another Lotus Notes database Create an automatic scheduled view export in Excel Top 10 LotusScript tips Create a personalized greeting for Lotus Notes database users Fail-safe rich-text validation using LotusScript LotusScript LotusScript equivalent of @Picklist for Lotus Notes Launch large attachments within an email from a Notes database How to find files on a hard drive or mapped network with LotusScript Update the ACL from the Roles view with LotusScript LotusScript agent moves tagged spam email to junk mail folder Create a personalized greeting for Lotus Notes database users Fail-safe rich-text validation using LotusScript How to export Lotus Notes views to a Microsoft Excel database Create file system labels for Microsoft Excel and Word mail merges Fix Lotus Notes 8.0 issues when launching Microsoft Office applications Lotus Notes 5 Track and record Lotus Notes user logins to Domino Server How to correct Lotus Notes public key mismatches in four easy steps Moving a remote user mail database to new Lotus Domino server OpenNTF OpenLog Calendar delegation problem with Lotus Notes client 6.5.5 upgrade Advice sought re lack of Notes/Outlook interoperability Availability of R6 update exam After Notes upgrade, LotusScript mail function doesn't work Beware of attachments when writing docs to mail.box in R6 Notes and Domino R5 exams to be retired RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.