I have a checkbox that is populated by a value list. The information will change from time to time so this seemed to be the best way to set it up. The checkbox items are displayed in alphabetical order but I would also like the resulting text field to be sorted alphabetically.

Example –

Checkbox 1 – Apple

Checkbox 2 – Pear

Checkbox 3 – Turnip

If a user selects the Turnip check box before the Apple checkbox – the resulting text field will be “Turnip Apple”

I would like the output to be sorted alphabetically – “Apple Turnip”

Is this possible?

The reason for this is that a report I created is treating the same output as multiple outputs depending on which item the user chose first.

Thanks

FilterValues ( ValueListItems ( Get ( FileName ) ; "YourValueListName" ) ; YourCheckboxField )

will give you ordered values.

Thank you for your help. I will give this a try.