dropdown arrow

  • Thread starter Thread starter lynn
  • Start date Start date
L

lynn

How do I format a combo on a form so it doesnt show the
selection (dropdown) arrow. I just want the field to
display the contents. It is not for editing purposes in
this form.
 
Hi Lynn

if you don't want a list and only want to display one value, right mouse
click on the combo box, choose change to & choose text box .. this should
give you what you're after.

Regards
JulieD
 
You can't. However, you CAN set the Locked property to YES, so that they
cannot select anything in the list.

I assume you want to do this because you are storing the value from a
reference table in your table and you want to display the corresponding
value from the other table.

Another thing you can do is create a new, unbound textbox (I'll call it
Text5 for convienence). In the On Current event of the form, have code
something like the following:
Private Sub Form_Current()
Me.Text5 = Me.Combo1.Column(1)
End Sub
Then make your combobox invisible. You can even put your textbox right on
top of the combo.
Note: the columns property starts counting from zero, so 1 is really the
second column.
 
Back
Top