combo box

[Guest]

I have a form and have a combo box with its row source as a table. The
dropdown only shows the 1st row of the text in the field(the x's but not the
z's). How can i get the z's to show without putting them in a seperate row in
the table.

1. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

2. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

 

[RuralGuy]

I have a form and have a combo box with its row source as a table. The
dropdown only shows the 1st row of the text in the field(the x's but not the
z's). How can i get the z's to show without putting them in a seperate row in
the table.

1. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

2. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

I would recommend using the wizard again to add another ComboBox and show the
fields you want.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Douglas J Steele]

Are you saying that when you're selecting a row from the combo box you see
both x and z, but once you've selected the row you only see the x?

In the combo box's AfterUpdate event, select the other field from the Column
collection and put it into an unbound text box:

Private Sub MyComboBox_AfterUpdate

Me.MyUnboundTextbox = Me.MyComboBox.Column(1)

End Sub

Note that the Column collection starts numbering at 0, so Column(1) is the
second column.