Controlling the order of list columns
I have a form with quite a few controls. The data presented are selected upon request. In some cases I want to go from form view to list view in VBA, however MS Access seems to have its own ideas on column order.
How can I control and make sure that the columns are displayed with feeling eg. always having a key (in my case the article number) in the first column followed by the main attributes?
source to share
From the look and feel of the information found here: http://www.access-programmers.co.uk/forums/showthread.php?t=203904 you just have to just set the column order for all your fields, An example they used:
Me.tblxx_Gemeinde_ID.ColumnOrder = 1
Me.vorschlag.ColumnOrder = 2
Me.tbl_Auftrag_ID.ColumnOrder = 3
Me.tblxx_Haushaltsabschnitte_ID.ColumnOrder = 4
Me.tblxx_Taetigkeit_id.ColumnOrder = 5
So I'll just add something like this to your VBA function that you use to change the view of the list. (This answer is based on the assumption that by the list view you mean the data table view.)
source to share