I fixed the problem by setting NumberOfElements to 10. Originally the last element was not shown and it probably affected the size.
>Still not sure I understand
>this only advice I could give (from experience) is to blank out .RowSource before refill, then reassign:
>
>.RowSource = ''
>select ... into array thisForm.someArray
>.RowSource = 'thisForm.someArray'
>
>
>>>it'd be nice and usefull to know how your code populates thisForm.aQuantityTypes
>>>
>>It first selects data from SQL Server in the cursor and then re-selects from the cursor into the array in the method called from Form's Load.
>>
>>Also, I tried setting ColumnsWidth in design time and it didn't help. I haven't yet tried in run-time.
>>
>>But I just noticed that I have a value pre-set in this drop down. Not sure why I did that, I'm going to try removing.
If it's not broken, fix it until it is.
My Blog