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

Posted on 2011-10-13
Medium Priority
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 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 668 total points
ID: 36961123
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

ID: 36961214

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 85
ID: 36961380
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.

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


Author Comment

ID: 36961479

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 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 664 total points
ID: 36961689

"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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 668 total points
ID: 36963165
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

578 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