I have built a form that dynamically displays checkboxes based on variables that have been previously entered into the system. I am using the contents of a multi-line field to appear as the value for the checkbox fields. This works well as long as the contents of the multi-line field remains fairly short. Unfortunately, most of the records that I want to use as values for the checkboxes are fairly long. (My application can generate 7-10 paragraphs on a form, each associated with a checkbox. Each paragraph can be fairly long). The form displays perfectly and looks great. The problem is that if a checkbox is selected and the value is too long, the record does not save and errors occur.

After testing, I have determined that the value of a checkbox field must be 237 characters or less. Interestingly, this limitation does not affect how the checkbox value is displayed. I have checkbox values that display perfectly on the form with well over 500 characters. Also, if multiple checkboxes are selected and each checkbox has a value that is 237 characters long (or less) the record will be saved without errors. To me this indicates that this is not a limitation of the number of characters that a checkbox value can store or display. (In other words, if I have one checkbox with a value that contains 238 characters I will get an error when trying to save the record. If I have three checkboxes with values that contain 237 characters each, the record will be saved with each 237 character value being saved in the checkbox field as part of the new 711 character stringlist.)

I would like to know if this is a bug. If not is there a workaround?  I am happy to save the record ID (instead of the entire paragraph from the multi-line field) that represents the paragraph that the user selects but I am not sure how to make this happen. I need to let the user choose from a list of fairly verbose options.

Thanks in advance for your help,

John