By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,663 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,663 IT Pros & Developers. It's quick & easy.

Sequence of columns in a datasheet subform

P: 5
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.
Sep 26 '08 #1
Share this Question
Share on Google+
7 Replies


DonRayner
Expert 100+
P: 489
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.
Sep 27 '08 #2

P: 5
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.
Sep 27 '08 #3

DonRayner
Expert 100+
P: 489
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.
Sep 27 '08 #4

NeoPa
Expert Mod 15k+
P: 31,271
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?
Sep 29 '08 #5

NeoPa
Expert Mod 15k+
P: 31,271
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.
Sep 29 '08 #6

P: 5
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.
Sep 29 '08 #7

DonRayner
Expert 100+
P: 489
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.
Sep 29 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.