Dropdown Arrow Resize?

[Bob]

Can the dropdown arrow be resized bigger than what it is?

Thanks in advance.........Bob Vance

 

[Douglas J. Steele]

Not really, but you could try pasting a command button with a large arrow
over top of dropdown area, and have the button's Click event invoke the
combo box's Dropdown method:

Private Sub MyButton_Click()

Me.MyCombo.Dropdown

End Sub

 

[Bob]

Douglas , my Dropdown combo box is cbActiveHorses
I created a command button what would be the code I should enter on click
thanks Bob

 

[Douglas J. Steele]

Forgot that the control needs to have focus before you can use the Dropdown
method, so you need both of the following:


Me.cbActiveHorses.SetFocus
Me.cbActiveHorses.Dropdown

or

With Me.cbActiveHorses
.SetFocus
.Dropdown
End With

 

[Bob]

Brilliant Douglas..thanx...Bob

Forgot that the control needs to have focus before you can use the
Dropdown method, so you need both of the following:


Me.cbActiveHorses.SetFocus
Me.cbActiveHorses.Dropdown

or

With Me.cbActiveHorses
.SetFocus
.Dropdown
End With