Access has some warped memory of column order for DataSheet view. When I ran into this problem, the only way I was able to resolve the problem was to rebuild the query (copy the string to notepad. then copy it back and paste it into a new query). But start by opening the form in form view and see if you can manipulate the show/hide columns properties. That might also fix it.