I have a row of checkboxes to speed up entry, but want their checked values to be pasted into a single text field. So if the checkbox items appear as [  ] apples  [X] oranges [  ] pears  [X] plumbs, I'd like the text field to have the checked values as words - oranges, plumbs. What options are there for this? It can be as the items are checked or after all the data is entered in the database for a given period.

I am not sure what you mean by "row of checkboxes".

If you have a field formatted as a checkbox set, using a value list of (apples, oranges, pears, plums), and the user has checked the values of oranges and plums, then the field already contains "the checked values as words" - separated by carriage returns.

To see this, place another instance of the field on the layout, format it as an edit box and make it tall enough to display all the checked values. Note that the values appear in the order in which the user selected them.

What else do you need?

 

OK got it. I'm just a bit rusty on that aspect and now I've sorted out how to combine it with other data. There's no option to close this post?