Forum Discussion
JohnShir
Apr 29, 2023Copper Contributor
Multi-Select List Box - sort when transferring values to field/row
Hi everyone, I’m trying to transfer the contents of a multi-select list box to a row/field with commas separating the values. I’ve done this using the MS Access 2010 wizard and it seems to wo...
George_Hepworth
Apr 29, 2023Silver Contributor
This could be done in a two-step process.
First, collect the items into an array.
Second, sort the items in that array.
I realize that is not a simple process, and arrays may be a new thing to learn. It would work, though. If you are willing to invest the effort in acquiring new skills, check it out.
This example is based on Excel, but the principle is the same.