dropdown arrow

[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.

 

[JulieD]

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

 

[Roger Carlson]

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.