Take your check box field, but leave it formatted as an edit box and you will see a list of each selected value separated by a return. A calculation field can be used to replace the returns with commas if you want a comma delimited list of these values.
I took a look at the first part of your answer but I need the checkbox field to remain as a checkbox field in the form.
What type of calculation would I need to extract the checked items in the field?
You don't need to change the field format where you use it for data entry. Use a check box format on the field on your data entry layout and use a plain edit box format on your report layout.
Hello and thank you for your followup PhilModJunk.
How exactly would I replace the returns for a comma? What would go into the calculation field?
Substitute ( YourCheckBoxFieldHere ; ¶ ; ", " )
That replaces the returns with a comma followed by a space.
Thank you PhilModjunk. It worked.
I was wondering of the options can be changed in the report. Say for example I have the options in present tense in the data entry form but want the checkbox options in past verb form in the report. Is this possible? I have done this with the Case command with radio buttons but don't know if that would work with checkboxes.
Thank you You have been very very patient and helpful.
It's possible. A Case function using Not IsEmpty (filterValues ( CheckboxField ; OneValue ) ) can be used to test to see if a specific value has been selected. A check box field can also be used as a match field to a related table and then a set of related records, one for each selected value might also produce this list.
But it sounds like you might be better off replacing your check box field with a portal to a related table where selecting a value creates a related record to show which value has been selected.