how to change order of columns in Datasheet View (MS-ACCESS)

[hstijnen]

Hi,

I've created a form in MSaccess with underlying query e.g. select a, b, c, d from table1.
Now when I run the form in Datasheet View the columns appear in a different order, e.g. a, c, d, b.
How can I change the order of columns in this view?

Thanks for help

Henk

 

[dhulbert]

Henk

You can just drag the fields around in datasheet view and then close the query. Re-open and they should be in the new order regardless of the order in the select statement.



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)