Problem With Column Order in Subform Datasheet View

[NoSmoke]

I'm getting no-where with this and am hoping someone can help. I have a subform in which I display a table in Datasheet View. The problem is, I cannot figure out how to place the columns in the order (i.e. from left to right) I want.

For some reason, right-clicking on a column header in Form View and selecting Freeze Fields will shift that column to the left but I can find no consistent pattern to it and no other way of shifting a column. Reordering the columns in the table itself seems to have no effect on the order they appear on the subform and moving the controls around in the subform in Design View also seems to have no effect.

Can anyone please offer a solution?

TIA for any help.

Also posted on Access World Forum BTW.

 

[NoSmoke]

S'OK - found how to do it. Move the cursor to the very bottom of the column header; the cursor changes to a four directional arrow and a vertical black bar appears to the left of the column; click and drag bar to the new column location.