How do change the column order in an Access 2010 datasheet form

Posted on 2011-10-13
Last Modified: 2012-05-12
Hi all,

I have created a datasheet style form and I want to arrange the order of the columns specifically. I know how to do this programmatically using the columnorder property but I actually just want to do it manually. I cannot seem to find the column order in any property list and if I move the column in datasheet view, it just jumps back to its original position when next opened.

I'm sure I am missing something obvious here...

Many thanks, in advance...
Question by:JohnSaint
    LVL 84

    Accepted Solution

    The ColumnOrder is, basically, the Tab Order of the controls.

    You could set the Tab Order via code, of course, but I'm not sure if you could do this without switching to Design view. You could store your column orders somewhere, and then reset them when the form opesn.

    Or you could base the form on a Query, and modify the SQL of that query to force the order of your columns (or just use a SELECT statement as the Recordsource of the form).

    You should also clear the OrderBy values of the form so that they don't interfere with your own Sort Orders - just do that in the Form's Close or Unload event:

    Me.OrderBy = ""


    Author Comment

    Hi LSM,

    I guess I want to know if I can manipulate the the column order without coding. I'm sure I used to be able to do it in 2003. Anyhow, I am going to look at the query option although and see how I go with that.

    The orderby property relates to the order of the records, I think. I am merley concerned with the column order at the moment...
    LVL 84
    If you mean you want to persist the tab order between form "sessions", then as far as I know you cannot.

    "The orderby property relates to the order of the records"

    You're right - I meant Sort Order, which can define how Accesss orders your columns (and can override your settings). You should clear that value, not Orderby.

    Author Comment


    I can't even find the 'Sort Order' property anywhere...

    I think I may have got to the bottom of it. I was failing to set the column order manually on a particular query based form. The form was created in Access 2003. I recreated the form from scratch in 2010 and it allowed me to manipulate as normal (manually). Hmmmmm. Perhaps there is some setting that my previous incumbent set up....

    LVL 119

    Assisted Solution

    by:Rey Obrero

    "you explicitly change the order of one or more fields in Datasheet view (either by dragging the fields to new positions or by changing their ColumnOrder property settings)"

    see this link for reference
    LVL 75

    Assisted Solution

    by:DatabaseMX (Joe Anderson - Access MVP)
    123 ... it's very easy.

    1) Open your datasheet form in normal view with at least one record.
    2) Drag the columns to the desired position
    3) File >> Save

    When you reopen the form, the columns will be in the same position.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now