I want to change the column widths of the combo box on a form based on conditions. I currently have what is below but it appears not to like it. I am sure my syntax is screwed up.
Code: Select all
Me.Combo6.Columns(1).ColumnWidth = 0
Me.Combo6.Columns(2).ColumnWidth = 0.75
Me.Combo6.Columns(3).ColumnWidth = 2.5
Me.Combo6.Columns(4).ColumnWidth = 1.3
Me.Combo6.Columns(5).ColumnWidth = 0.5
Me.Combo6.Columns(6).ColumnWidth = 1
Me.Combo6.Columns(7).ColumnWidth = 1
Mark