Form in Datasheet View - Column Order

[Simon Harris]

Hi All,

I'm trying to change the column order for a form that is viewed as a
datasheet. I've tried moving the form elements, changing the tab order, and
the column order for the the query driving the form, none of these have
worked...help!

Thanks!
Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!

 

[Guest]

Hi Simon

Think you may be looking for a complicated answer - there are loads - BUT
the simplest method is to open the datasheet and select the column that you
want to move (click the top of the column till it black's out) and simply
drag it to where you want it then save. Close and open the form and you'll
see it's how you left it.

Hope this helps

 

[Simon Harris]

"Think you may be looking for a complicated answer"
Nope...The simple option will do nicely!

Thanks Wayne - Much appreciated.

Simon.

 

[fredg]

Hi All,

I'm trying to change the column order for a form that is viewed as a
datasheet. I've tried moving the form elements, changing the tab order, and
the column order for the the query driving the form, none of these have
worked...help!

Thanks!
Simon.

Did you (in Form Datasheet View) select the entire column (click on
the column header) and then left-click, hold, and drag the column
where you want it? Works for me.

if you want to use code, code the form's Load event:
Me![ControlName].ColumnOrder = x
Where x is the column number you want.