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

[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

 

[Paolo]

Hi Kosh,
use a list box, so you'll get rid of the arrow.
HTH Paolo

 

[John Spencer]

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

 

[Albert D. Kallal]

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