Isn't grid order determined by tab index

[Bev Kaufman]

I have always been under the impression that fields are displayed in a grid
according to the tab index order. But I am looking at a grid that displays
the following fields in this order:
Est. Fee (tab 4), Date (tab 5), Number (tab 8), Sales (tab 6).

If it is not tab index that determines the grid order, then what is?

 

[vanderghast]

The tab order determines the order in which the controls will be visited
with the tabkey.

The order in the grid (?), I assume you mean disposition on a form, is
determined by the top and left property of the control.

Vanderghast, Access MVP

 

[John W. Vinson]

I have always been under the impression that fields are displayed in a grid
according to the tab index order. But I am looking at a grid that displays
the following fields in this order:
Est. Fee (tab 4), Date (tab 5), Number (tab 8), Sales (tab 6).

If it is not tab index that determines the grid order, then what is?

What do you mean by "a grid"? That's not a term in use in standard Access
databases.

If you mean a Datasheet, the order of columns is the order of fieldnames in
the Query.

If you mean a (third party) Grid control, you'll need to examine the
properties of the grid control, but my guess is that it would also honor the
field order of the query.

 

[David W. Fenton]

What do you mean by "a grid"? That's not a term in use in standard
Access databases.

If you mean a Datasheet, the order of columns is the order of
fieldnames in the Query.

But not entirely. You can drag the columns, as well as resize them,
and those properties are saved. I suspect they are accessible
somewhere, but likely only via Screen.ActiveDatasheet (and underused
object, seems to me, given that you can assign actions to events
with it).