Combo Box

[gyckl]

Hi

I have built a form where the user can tick an Active x Combo box to select the service they require.

However, every time I tick a box the box itself seems to increase in size to a degree that the form looks really messy .. I have tried not moving and sizing with cells from the properties function but this does not work - they just keep increasing in size the more times they are selected.

Has anybody had this issue before or know how to solve it - I need to present this model to our Sales Director tomorrow and i'm beginning to panic (spent all last night trying to sort it out with no success )

Any help much appreciated

Many Thanks

Chris

 

[Sektor]

1. Right-click combo
2. Format Control
3. Properties
4. Don't move or size with cells

 

[gyckl]

Thanks Sektor - I have already tried this but it doesn't seem to work - they just keep on increasing in size.
Don't suppose you know anything else that might work do you?

 

[Sektor]

In Forms designer write down two properties: Width and Height.
Then in the end of Click event assign these digits to these properties.

Private Sub ComboBox1_Click()
    
    ' Your code......
    
    ' In the end of procedure
    ComboBox1.Width = 100 ' <--- Your digit
    ComboBox1.Height = 10  ' <--- Your digit

End Sub