Change Drop Down Arrow Size on Combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Timboo - 18 Jan 2005 14:59 GMT

When you resize a drop down or combo box, although the "data area" grows as
you make the object larger, the actual drop down arrow (icon) stays the same
size. Without resorting to changing the screen resolution, is there a way to
make this part of the tool larger. The reason I ask is that my users are
using a touch screen, and I want each button the be as large as the end of an
average finger, and I would like the Combo box tool as a similar size.

Thank you Tim.

Reply to this Message

Brendan Reynolds - 18 Jan 2005 16:15 GMT

I don't believe so, no. What you could do is place a command button beside
the combo box, and add the line 'Me.NameOfComboBoxHere.DropDown' to the
Click event of the combo box.

Signature

Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

> When you resize a drop down or combo box, although the "data area" grows
> as
[quoted text clipped - 8 lines]
>
> Thank you Tim.

Reply to this Message

Timboo - 19 Jan 2005 07:47 GMT

Brendan, thank you, will do just that. Tim

> I don't believe so, no. What you could do is place a command button beside
> the combo box, and add the line 'Me.NameOfComboBoxHere.DropDown' to the
[quoted text clipped - 12 lines]
> >
> > Thank you Tim.

Reply to this Message

Timboo - 19 Jan 2005 09:09 GMT

Brendan, I now get the error message “You cant reference a property or method
for a control unless the control has focus” I guess clicking on the button
sets the focus off the combo control and onto the button itself. Is there a
line of code I can use behind the button to set the focus on the combo box,
and then action the button event? Something like "setfocus me.combo26 then
me.combo26.DropDown" thanks Tim

Reply to this Message

Brendan Reynolds - 19 Jan 2005 11:33 GMT

This should do it - just replace 'cmdTest' with the name of your command
button, and 'cboTest' with the name of your combo box.

Private Sub cmdTest_Click()

Me!cboTest.SetFocus
Me!cboTest.Dropdown

End Sub

Signature

> Brendan, I now get the error message "You cant reference a property or
> method
[quoted text clipped - 28 lines]
>> >
>> > Thank you Tim.

Reply to this Message

Timboo - 19 Jan 2005 11:51 GMT

Brendan, thank you again, will try this tomorrow, as Im doing a presentation
with this prototype this afternoon, and dont want to change anything as IVe
doen screen shots ... and incase I corrupt something!

Tim

> This should do it - just replace 'cmdTest' with the name of your command
> button, and 'cboTest' with the name of your combo box.
[quoted text clipped - 38 lines]
> >> >
> >> > Thank you Tim.

Reply to this Message