InfoPath Rich Text Box Limit

The InfoPath rich text box limit is 25,700 characters (with spaces).  How do I know this?  Trial and error.....This is the popup message that refers to the InfoPath text box limit:

Good job InfoPath! Now someone has to delete their content until they are below that special limit (that you have no way of knowing while working with an our-of-the-box InfoPath rich text box). 

 

Anyways, for some reason I can't seem to find any information online for InfoPath's rich text box limit, so that is why I am writing about it.  

Why is it important?  For most of you it is not important, or at least not important right now.  What makes this topic important is the cool merge capability of InfoPath - the ability to merge several InfoPath data fields into one data field (also creates a new InfoPath form in the process). 

If you are merging a lot of these InfoPath forms at once and want to capture ALL of the rich text box data, then it is important to set limits or restrictions for how much a user can type, or to just plan ahead before you have to merge 1,000 reports at the end of the year. There are many ways around getting stuck, one is do several smaller merges and just edit the rich text box fields to only include the most important info, then to do a final merge of all of the smaller merged forms.  

If you are considering doing an end-of-the-year merge of X # of reports, then use the simple math equation below to see if you will approach the rich text box field limit or not:

# of InfoPath forms submitted in a week * average # of characters with spaces per InfoPath form * how many weeks of InfoPath forms you want to merge:

Example:

100 submitters

200 characters with spaces in each report

Quarterly merge required (for simplicity, lets assume every month is 28 days), so a total of 12 weeks

100*200*12 = 240,000 characters with spaces!  Oh No! Looks like someone needs to reconsider their approach for this issue.  

On a side note-this whole InfoPath rich text box problem is not a problem if you aren't going to edit any of the rich text box data after the merge.  All you'll get is a warning popup and then you can save it to SharePoint.  But, if you are over the rich text box limit then you can only delete data (not add anything) until you are below the limit.