... Column1.ColumnOrder = 2 Column1.ControlSource = "Field1" Column1.Width = 75 Column1.Name = "Column1" Column2.ColumnOrder = 1 Column2.ControlSource = "Field2" Column2.Width = 75 Column2.Name = "Column2" ...Now let's edit it to swap these two columns physically:
Column1.ColumnOrder = 1 Column1.ControlSource = "Field2" Column1.Width = 75 Column1.Name = "Column2" Column2.ColumnOrder = 2 Column2.ControlSource = "Field1" Column2.Width = 75 Column2.Name = "Column1"You need to change both the order of text rows and system names like "Column1", "Column2", etc to reflect the new order. The Name property must stay untouched to preserve binding of columns' child objects.