Share via

Sort order in the Expression Builder

Anonymous
2011-09-16T21:22:36+00:00

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?

(They are certainly not in alpha order, nor the order in which they are added to the form, nor the Tab order)

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-09-17T19:30:47+00:00

    Hmm, perhaps there is a reason... however, I have no idea what it is.  If I get time this weekend I might look into this!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-09-17T06:57:29+00:00

    A bit of testing has revealed a little bit more.

    The order is the same as in the list produced by this procedure:

    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

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-09-17T05:28:25+00:00

    Thanks for that answer.

    Like you I hope it gets fixed one day.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-09-17T04:57:53+00:00

    As far as I know there is no ryhme or reason (or order) to that AND no way to create one.  And yes, it is annoying if you have a lot of fields.  I would especially happy if oneday that gets fixed!

    Was this answer helpful?

    0 comments