Hi guys,
I have a combo box and a text box, I pick a data item from the drop down of the combo box, I want that the data item is transferred to the text box, I tried
Private Sub ComboBoxName_AfterUpdate()
TextBoxName.Value = ComboBoxName.Value
End Sub
and also tried
Private Sub ComboBoxName_AfterUpdate()
Me.TextBoxName= Me.ComboBoxName.Column(2)
End Sub
Both of them worked, but just worked partially, I mean when the data item of the combo box (a text) is too long, it cannot fully be transferred to the text box.
Could I please receive some help, thank in advance.
I have a combo box and a text box, I pick a data item from the drop down of the combo box, I want that the data item is transferred to the text box, I tried
Private Sub ComboBoxName_AfterUpdate()
TextBoxName.Value = ComboBoxName.Value
End Sub
and also tried
Private Sub ComboBoxName_AfterUpdate()
Me.TextBoxName= Me.ComboBoxName.Column(2)
End Sub
Both of them worked, but just worked partially, I mean when the data item of the combo box (a text) is too long, it cannot fully be transferred to the text box.
Could I please receive some help, thank in advance.