I'm trying to have a field that is a Combo Box and fulfills the following criteria:
(1) Allows multiple values
(2) Allows value list edits
(3) Can be sorted alphabetically.
I find that I can only achieve 2 out of the 3 with any given solution.
Attempt 1
Row Source Type = Value List
Row Source = a;b;c
Allow Multiple Values = Yes
Allow Value List Edits = Yes
Fulfills Criteria 1 and 2 but not 3
Attempt 2
Row Source Type = Table/Query
Row Source = Query
Allow Multiple Values = Yes
Allow Value List Edits = Yes
Fulfills Criteria 1 and 3 but not 2
Does anyone know if this is possible, or am I trying to achieve too much at once?