[AccessD] List order in listbox

dw-murphy at cox.net dw-murphy at cox.net
Wed Feb 15 12:57:07 CST 2023


Folks,

Have not been doing much Access as I have pretty much fully retired. I am creating a small Access application for a group I belong to. While some things take a little longer is seems I have retained most of the basics. One thing that isn't working is getting a list box to sort properly. The row source for the list box is a saved query that filters from the ID value of the form the list box is on. My recollections is the list box reflects the sorting of its row source, in this case the query.  When I open the query it sorts properly. The list box is sorting alphabetically on the visible field, not on the not visible column that it should be. The sort column is available in the listbox, but has it's column width set to 0. Not sure what is going on here. 

Doug



More information about the AccessD mailing list