Disabling the drop down arrow displaying

P

Philip

In a combo box, how do i prevent the drop down arrow displaying on the form ?

Is this even possible.
 
A

Albert D.Kallal

Are trying to prevent the drop down arrow because you don't like it, or in
fact do you NOT want users to have a choice?

If you are just displaying data from another table, then you can eliminate
the combo box, and base the form on a query that left joins in the
additional values from the other table. You can then use standard text boxes
on the form..and don't need combo.

In a good number of cases, people want the drop down arrow to not appear to
save room on a screen, or reduce clutter. In this case, you can place a
text box on top, and then when the text box gets the focus, you enable, and
set the visible of the combo box = true, and then set the focus to the
combo.

So, your solution really kind of depends on why you don't want the drop down
arrow.
 
P

Philip

Thanks, i dont want the 'clutter' as well as not wanting people to have the
choice - im just displaying the info. I will make the changes you suggested

Thanks !
 
Top