In MS Access, how can I not show the down arrow for a Combo Box?

  • Thread starter Thread starter kosh
  • Start date Start date
K

kosh

I would like to display a Combo box without seeing the down arrow on either
the left or right. I plan on using the Me.MyCombo.Dropdown statement when I
set focus on that Combo box.

Please advise.

Thank you
Kosh
 
kosh said:
I would like to display a Combo box without seeing the down arrow on
either the left or right. I plan on using the Me.MyCombo.Dropdown
statement when I set focus on that Combo box.

Please advise.
Click to expand...

My advice is forget the idea. The Access ComboBox has no feature for
eliminating the arrow. You can cover it with a rectangle, but when it gets
focus the control will move in front of that and you will see the arrow
anyway.
 
Can I suggest that you think some more about why do you want to do this.

The combobox is a standard user interface and users would see the drop-down
arrow and know what behavior to expect.


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Funny you bring this up, but some of us developers Were just discussing this
issue the other day.

Someone did comment if you do use a datasheet in place of a continuous form,
then the drop down arrow actually does not show until the cursor moves into
that particular column.

I suppose another way would be to make the combo box hidden, use a text box
for that column, and then when the cursor moves into that text box you
enabled the combo box and set the focus to it. unfortunately the drop down
arrow who would thus appear for all rows of that column in a continuous form
if you did that.

Your choice is pretty much either use a datasheet view, or simply live with
this little quirk of the interface, which as some mentioned is actually not
that bad of a thing anyway
 
Back
Top