Changing the column order in the datasheet part of a split form (Access 2007)

[Kafrin]

SOLVED: Changing the column order in the datasheet part of a split form (Access 2007)

Hi guys,

I've been getting to grips with Access 2007 recently and have run up against a problem with split forms.

I have a split form with >30 fields. The fields/columns in the datasheet are not in an obvious order - they're not following the form's tab order or the field order of the recordsource (although only some fields are out of place, but this includes the primary key).

So my questions are:
1) What determines the order the fields are shown in the datasheet part of a split form?
2) Can I change the order of the columns? If so how? (I know how to resize them and therefore hide them, but not how to move them.)

Thanks!

 

[kvar]

If you view the form in datasheet view, you can click on the column name, the down arrow, to select the whole column.
Then just click and drag it to where you want it.
Hit save, the new layout should be saved.

 

[Kafrin]

Thank you kvar!

That works perfectly. It now seems so obvious, but I was thinking along commpletely the wrong lines so I'd never have got there on my own.

 

[kvar]

Glad I could help!
We all try to make things more complicated than they are at times......I'm known to do it a LOT!!

 

[Kafrin]

I've now discovered you can also move the columns around in Layout view, which is handy.