Hi,

We have developed a catalogue publishing database that includes a list of colour options for each product. The list is populated by a Multi Select field from a pre determined list of colour options. I have specified Alphabetical order for the list. When editing the record the colours appear in ascending alphabetical order, however when exporting of viewing the record the list is reversed. It is important for the catalogue that the colours appear in ascending alphabetical order. Is there any way if changing the order of the list?

Example: list appears while editing: AQ,BL,L,R (which is what we need)

Thanks for your help.