Alphabetize value list in combo box

[ernielippert]

I have a combo box based on a value list:
Row Source: is a list of values "A","C","B","H",...
Row Source Type: Value List
There is no table, query, or SQL behind this combo box. How do I alphabetize the list of values in the Row Source without having to reconstruct the application? This is a canned application downloaded from Microsoft, Access 2010.
Thanks,
Ernie

 

[AccessMSSQL]

not possible without storing the values in a table. Do you have control over the design or is it locked down? Easy to just create a quick table with one field and the values in it.

 

[ernielippert]

Thanks very much. I will do as you suggest.
Thanks,
Ernie

 

[Galaxiom]

not possible without storing the values in a table.

Well actually it is possible and not particularly difficult. It would be done by parsing the RowSource string. It just would be an unlikely choice to use that technique when a table or recordset can be used.