We help IT Professionals succeed at work.

Control the orders of columns in datasheet form 2010

Hi
I need to reorder the columns in datasheet  subform .
In access 2003 I was just drag the column to the place needed and then save it , and that’s all.
I try it several times in access 2010, but no way.
Please help
1.JPG
Comment
Watch Question

Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010
Commented:
Open the datasheet by itself (not as a subform).

Drag the column where you want it, then save the form.  Then open it via your main form and it should be where you want it.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
Make sure that your datasheet columns are not frozen by unfreezing all columns.

There is an image of this in the following article:
http://office.microsoft.com/en-us/access-help/freeze-fields-in-an-access-datasheet-HA102489824.aspx
MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
1. For fun, just try changing the "Tab Order" of the subform...

2. Also make sure that you actually created a "datasheet" form.
I just created a datasheet form in 2010 and I was able to move the columns just fine...

3. The "Multiple Items" or "Tabular" (continuous) form options are not the same thing as a datasheet form, even though they look similar (display multiple records).

To be sure, to move a column in a datasheet view form:
a. Click once *and release* the column heading.
b. Then click *and Hold* the column heading, then you will see a back line (as you move the column) indicating where it will be moved to.
c. Then simply drop (release) the column.

Final Notes:
Make sure the default view of this subform is actually set to: "Datasheet View"


;-)

JeffCoachman

Sample attached
Database531.accdb
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
You can do it in VBA code ... in the OnLoad of the Form ... that way, it will always be what you want it to be ...

This shows how:
http://msdn.microsoft.com/en-us/library/ff822068.aspx

mx
Mohammad Alsolaimanapplication programmer

Author

Commented:
boag2000: For fun, just try changing the "Tab Order" of the subform...
yes that was the problem in my case
i had try whats : fyed & mbizup say but nothing .
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
OK, but again, in the sample I posted I was able to "move" the colums just fine.
This is what mbizup suggested as well...

Are you saying that this did not work for you, ...even in the sample I posted?
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
Jeff,

My understanding is that he is saying your suggestion worked, and that he may have simply  forgotten to close the question.
Mohammad Alsolaimanapplication programmer

Author

Commented:
boag2000: Are you saying that this did not work for you, ...even in the sample I posted?
your sample is work fine in the subform datasheet, but not in the report.
the  "Tab Order" is work fine with me
maybe some thing concern in my accdb or the arabic version, not sure.
anyway it works good right now by adjusting the column tabs order
Mohammad Alsolaimanapplication programmer

Author

Commented:
thanks to all of you for the good information
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
OK

;-)

Jeff

Explore More ContentExplore courses, solutions, and other research materials related to this topic.