Sort order in the Expression Builder

Topic

New Reply

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?

28916-ExpressionBuilderSort

Reply | Quote

Replies

I’m guessing it is because that is the order the objects were added to the form.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

Thanks for that suggestion Boyd, I have posted the question there.

Reply | Quote

Please let us know what you find out.

Reply | Quote

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

Reply | Quote