Posted 1 October 2022, 1:07 am EST
Hello there,
Here is my code to bind my column with multicombobox. When I start typing in this column the multicombobox does not appears. When I click on button then only it populates. Can you please guide me how to populate multicomboxbox and display all fields of mcb when user starts typing?
Dim QryX1 As String
Dim TableX1 As New DataTable
Dim AdapterX1 As New SqlDataAdapter
QryX1 = "Select ActName As [A/c. Title], ActCode as [Code] From TblAcFile Order by ActName"
TableX1 = New DataTable
AdapterX1 = New SqlDataAdapter(QryX1, Conn)
AdapterX1.Fill(TableX1)
mcb.DataSourceList = TableX1
mcb.DataColumn = 1
mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Right
mcb.ListWidth = 600
mcb.ListOffset = 5
mcb.MaxDrop = 15
mcb.AutoSearch = AutoSearch.MultipleCharacter
mcb.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows
mcb.StringTrim = StringTrimming.EllipsisCharacter
mcb.ListResizeColumns = ListResizeColumns.FitWidestItem
For A1 = 0 To FpPartInterchanges.Sheets(0).RowCount - 1
FpPartInterchanges.ActiveSheet.Cells(A1, 2).CellType = mcb
Next
```[img]https://gccontent.blob.core.windows.net/forum-uploads/file-10d1d296-2ad8-4369-8637-54896eed92e1.png[/img][img]https://gccontent.blob.core.windows.net/forum-uploads/file-fa409b7e-dcf2-424d-8800-0e8a83a38291.png[/img]
