[AccessD] List order in listbox

[Doug Murphy]

It is visible and set to 0. I did remember that much. Still doesn’t sort right.

Sent from my iPhone

> On Feb 15, 2023, at 11:45 AM, Daniel Waters <df.waters at outlook.com> wrote:
> 
> Hi Doug,
> 
> My vague memory of this is that the sort column should be set to visible, but it's width should be 0.  I think that if the sort column is set to not visible then the control doesn't recognize it at all.
> 
> Good Luck!
> Dan
> 
> -----Original Message-----
> From: AccessD <accessd-bounces+df.waters=outlook.com at databaseadvisors.com> On Behalf Of dw-murphy at cox.net
> Sent: 15 February, 2023 12:57
> To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
> Subject: [AccessD] List order in listbox
> 
> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com