Column Order in form Datasheet View

[Christine Jackson]

Hi

Simple question i know, but unfortuantely its driving me crazy. Is there anyway I can alter the order in which columns are shown in Datasheet View on a Form so that it opens up in the same order next time i open it?

Thanks

Chris

 

[Galaxiom]

Use the Object Browser (F2 key) in the VB Editor. It reveals much about objects.

Another useful piece of code is a loop through the properties of an object. For example, type this line into the Immediate Window to reveal the names of the properties of a field.

Set db = CurrentDb: For Each p In db.TableDefs("Table1").Fields("fieldname").Properties: ? p.Name: Next

Similar lines can be applied to any object and it is so fast to do that it is a useful alternative to the Object Explorer of even looking at the design view of the object.

Properties of a control:

For Each p In Forms.formname.controlname.Properties: ? p.Name: Next

It will often suggest where you should be investigating.

 

[Mr. B]

Check out this article:
http://office.microsoft.com/en-us/a...-order-of-columns-in-a-table-HA010341931.aspx

 

[RainLover]

This should do the trick.

Me.Student_ID.ColumnOrder = 1
Me.Family_Name.ColumnOrder = 2
Me.Preferred_Name.ColumnOrder = 3

etc

 

[Christine Jackson]

Worked a treat -

Many thanks

Chris

 

[RainLover]

Good to see it worked for you.

 

[BMiles13]

I found the following to work for me:

1. [FONT=&quot]Open the form that has all of the subforms on it.[/FONT]
2. [FONT=&quot]re-arrange or size the fields in the subforms as you wish them to be[/FONT]
3. [FONT=&quot]click on (highlight) one of the columns in the subform[/FONT]
4. [FONT=&quot]on the ribbon, in the text formatting group, center this column (or change any attribute in the text formatting group), then change it back to left justified (or Bold and then un-bold the subform)[/FONT]
5. [FONT=&quot]Now - close the form, you will be prompted to save, do so[/FONT]

Your subform should now have all of your changes.
Has worked for me without fail

 

[cgtuttle]

BMiles13 - that actually worked! Thanks!

 

[PaulA]

BMiles13's idea worked for me - and it's simple!

Thanks!

 

[sxschech]

A thought...if you go with RainLovers idea, you could then put a button on the form called "Reset Col Order" then if a user has a custom order, they can drag cols around and reset them to the preferred order.

 

[OriOn]

Hello there!

I also noticed that, in design mode, the "Tab order" (available in the tab "Other" of the property sheet) is reflecting the column ordering of the datasheet view.

It also works with split forms.

Just to complete the panel of answers already given here.

 

[gaspar.illes]

Hi, thank you all of the answers. It was extremely useful form me.

 

[micniv]

Great thanks to BMiles13
I've spent hours trying to set one column as the 2nd column.
Without Bmiles13's solution, I would have got nuts !
Thanks again,
Michel