Sort ListBox Value List

[bulrush]

Access 2003 on WiN XP

Ok, I've been searching this site and Google for an answer and have not found one yet.

I have a single column list box with a Value List (items separated by semi-colons). How do I sort them in ascending order? I swear Access used to have this in A95/97, now it doesn't seem to.

Does Access have an internal object to help me sort a list of items? I could put my Value List into this special array, have the object sort it, and recreate the Value List with semi-colons again, then assign to my ListBox Rowsource.

Thanks.

 

[Steve R.]

You need to use "ORDER BY" in your row source.

SELECT RepsNameID, RepsName FROM dbo_RepsList WHERE RepActive=true ORDER BY RepsName;