Results 1 to 7 of 7
  1. #1
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Sort order in the Expression Builder

    The middle box of the Expression Builder can list all the objects on a selected form or report.

    I always find it hard to find things in the list as they seem to be in a completely random order.
    Or is there some order there that I can't see?

    ExpressionBuilderSort.gif
    Regards
    John



  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    I'm guessing it is because that is the order the objects were added to the form.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by MarkLiquorman View Post
    I'm guessing it is because that is the order the objects were added to the form.
    I agree that sounds like a reasonable guess, but it is not accurate.

    I did some testing on this, the latest addition was down towards the bottom, but not last.

    Because I did not seem to be getting any response here, I also posted this question here where there is some discussion.
    Regards
    John



  4. #4
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    I would suggest posting it to Microsoft Answers if you want the Access team to chime in.

    Boyd Trimmell aka HiTechCoach
    Microsoft MVP - Access Expert


    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Thanks for that suggestion Boyd, I have posted the question there.
    Regards
    John



  6. #6
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Please let us know what you find out.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Nothing much to report. Gina Whip has responded that she too finds it annoying.

    I did a test and found that the list produced by this routine lists items in the same order as the Expression Builder.

    Code:
    Public Sub sbListControls(frmForm As Form)
        Dim ctrl As Control
        For Each ctrl In frmForm.Controls
            Debug.Print ctrl.Name
        Next ctrl
        Set ctrl = Nothing
    End Sub
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •