I am using the latest version of the controls in Vb.

I have data table that is a reference table with a column contains values which can be > 1000 characters but is typically < 200.

Before I realized that the Ultracombo cannot do multiline text in the textbox portion of the control I tried to use one for the user to select from

and I have now changed to an Ultragrid and added an ultradrodown. Given the type of data that is in the database (medications) it is

considered unsafe practice to have the system AutoSelect rows. I have set  AutoCompleteMode = Infragistics.Win.AutoCompleteMode.None but to

No avail the grid continues to do what seems to me to be Infragistics.Win.AutoCompleteMode.SuggestAppend.

I need either just Infragistics.Win.AutoCompleteMode.Suggest or Infragistics.Win.AutoCompleteMode.None to work. Please advise

Some code that maybe relevant:

   Dim DA As New SqlDataAdapter(SQLCmdMedicinal)
   DA.Fill(DSMedicinal)
   uddAMTMedicinal.SetDataBinding(DSMedicinal, DSMedicinal.Tables(0).TableName)
    With uddAMTMedicinal 'the ultra drop down
                     With .DisplayLayout
                         .Override.CellClickAction = UltraWinGrid.CellClickAction.RowSelect
                         With .Bands(0)
                            If .Columns.Exists("referencedComponentId") Then .Columns("referencedComponentId").Hidden = True
                            .SortedColumns.Clear()
                            If .Columns.Exists("Term") Then
                                .SortedColumns.Add("Term", False, False)
                                With .Columns("Term")
                                    .Width = 250
                                    .AllowRowFiltering = DefaultableBoolean.False
                                    .FilterOperatorDefaultValue = FilterOperatorDefaultValue.Like
                                    .AutoCompleteMode = Infragistics.Win.AutoCompleteMode.Suggest
                                    .AutoSuggestFilterMode = AutoSuggestFilterMode.StartsWith
                                    .FilterEvaluationTrigger = FilterEvaluationTrigger.OnCellValueChange
                                    .SortComparisonType = SortComparisonType.CaseInsensitive
                                End With
                            End If
                        End With
                    End With
 
                    .DropDownSearchMethod = DropDownSearchMethod.Binary
 
                    '   Set the ValueMember property to the referencedComponentId field of the Medicinal Items
                    '   table. The ValueMember property specifies the column in the UltraDropDown control
                    '   that will supply the value to the UltraGrid cell, analogous to a ValueListItem's DataValue
                    .ValueMember = "referencedComponentId"
 
                    '   Set the DisplayMember property to the TErm field of the Medication Items
                    '   table. The DisplayMember property specifies the column in the UltraDropDown control
                    '   that will supply the display text to the UltraGrid cell, analogous to a ValueListItem's DisplayText
                    .DisplayMember = "Term"

Thank you