Sequence of columns in a datasheet subform

[MayoM]

Access 2003 has suddenly reordered the sequence of columns in a datasheet subform.

Specifically the last column has stayed in place but the others are back to front. There are about 50 columns in total.

Any ideas as to what is causing this? And what is a permanent solution?

I had a assumed that the sequence was taken from the sequence of the columns in the query in the form's record source. But as this hasn't changed I don't know if there is another place where the column sequence is recorded.

I can drag the columns back into the correct sequence but this has not prevented another involuntary reordering of the columns.

[DonRayner]

When datasheets start acting up on me I normally select all of the columns then on the format menu I select Freeze columns. They normally behave after that.

[MayoM]

Thanks for the suggestion.

I have just frozen all the columns.

But now the horizontal scroll bar has disappeared and all the columns over to the right are unreachable.

[DonRayner]

Thanks for the suggestion.

I have just frozen all the columns.

But now the horizontal scroll bar has disappeared and all the columns over to the right are unreachable.

Check the formating for the subform itself (not the formating for the subform control on the main form) and make sure that the scroll bars are set for both.

[NeoPa]

When you run the query simply as a query, are the columns in the same order as the form or do they match the order listed in the query?

[NeoPa]

In a query display, it is possible to move columns around by dragging them with a mouse. This doesn't change the order of the columns in the query definition (nor the underlying SQL itself).

Your problem sounds similar to this so it may be worth checking if it behaves that way.

[MayoM]

Thanks for the replies

a) Concerning the horizontal scroll bar: The subform has both specified. It just seems that if I freeze columns which extend beyond the width of the screen the horizontal scroll bar disappears (or maybe moves over to an invisible position over to the right)

b) Concerning the underlying query: The fields are in the sequence which I want displayed (and in which were the fields were displayed originally).

So the it seems that freezing columns is not really a solution and the only way of correcting the sequence is to drag the columns when in Form View.

[DonRayner]

Thanks for the replies

a) Concerning the horizontal scroll bar: The subform has both specified. It just seems that if I freeze columns which extend beyond the width of the screen the horizontal scroll bar disappears (or maybe moves over to an invisible position over to the right)

b) Concerning the underlying query: The fields are in the sequence which I want displayed (and in which were the fields were displayed originally).

So the it seems that freezing columns is not really a solution and the only way of correcting the sequence is to drag the columns when in Form View.

Sorry the freeze didn't work, I never use datasheet view when I can't display all of the data in the space available so had never run accross the problem.

I did take a closer look at it and the order that the colums are defaulted to seams to be the same order as the tab index for form view. I tried making changes to these in one of my test databases and it changed the order in the datasheet view.