• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

List Box column sequence in incorrect order (1 Viewer)

HelpMoses76

Member
Local time
Yesterday, 22:36
Joined
Sep 17, 2020
Messages
37
When I assign the row source property via code or within properties box for a List Box...the order of the columns is not what I went it to be .Any ideas how to achieve the exact sequence of columns need . please help.

Thanks

Moses
 

Isaac

Lifelong Learner
Local time
Yesterday, 19:36
Joined
Mar 14, 2017
Messages
2,330
They should match the order in which you choose to Select them in the Select query, i.e.:
select col1, col2 from table1
should result in col1 being first lb column col2 being second one. Do they?
 

HelpMoses76

Member
Local time
Yesterday, 22:36
Joined
Sep 17, 2020
Messages
37
Unfortunately that does not help either . it reverses the order . instead of it showing left to right...it shows right to left.
 

Isaac

Lifelong Learner
Local time
Yesterday, 19:36
Joined
Mar 14, 2017
Messages
2,330
See if the attached explanation helps - see the queries and mostly the Form...
 

Attachments

  • Testing 20200917 LB col order.accdb
    512 KB · Views: 9

HelpMoses76

Member
Local time
Yesterday, 22:36
Joined
Sep 17, 2020
Messages
37
Thank you . I will try this again . I suspect I have in the past as well.
 

Users who are viewing this thread

Top Bottom