Forum Discussion
Problem with an Access table
Hello. I have a little problem using Microsoft 365 Access: In some table of of one of my BD's, the order of the colummns that Design View shows is some different that Data Sheet shows. Why this issue happens and what must I do to fix it? Thanks for your answers.
Guillermo Gartner
email address removed for privacy reasons
Hi,
In datasheet view, click on the gray border above a column containing the column name, hold down the mouse button, drag the column to the desired position and drop it there.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEKHello Karl. I want to thank you a lot for your kind answer of this week. Indeed, with your suggestion I solved my little issue, but I would wish to know why these things happens. As i mentioned in my question, if I see the Design View, this column is in its correctly position but in the Data Sheet View it is in another position. What could cause this issue? Thanks again por your new answer.
Sincerely yours
gegar14
Hi,
As you have seen, you can change the position of the column in datasheet view at any time without affecting the position of the field in design view. So if someone does this intentionally or unintentionally (e.g. mouse slip), the positions will no longer match.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK
