You need to use the cells of the igCellCombo type. They are not editable as text, but the incremental search is supported. Cells of these type store combo box item values in their cell values, so your task becomes trivial: you just read the CellValue property for the required cell.

I can think about a workaround or tool to retrieve the internal index of the combo item. But can you tell me the logic of your app related to these cells? I think there should be a special processing of new entered strings that are not on the list: you need to add them to the db from code, retrieve their IDs, add them to the combo list attached to the cell, etc.

• When a user selects a listed town, to store the ID in the database, developer must do a binary recursive search in Combo Box items (or loop) to find the corresponding Index of the displayed text, so that you can retrieve the ItemValue and store it.
• When user enters a new town, developer must do again a binary recursive search in Combo Box items to find if the town is listed. If not, new Town must be added to the database and repopulate the combo box to include the new value or must find by code the proper index to insert it.

The problem with the igCellTextCombo cells is that their values are not linked to the combo list item values as the user can enter any arbitrary text. iGrid and its combo lists are not bound to data sources. If they were so, perhaps, we could even implement some smart logic to add new missing cell texts automatically to combo lists.

Some time ago we implemented the ability to retrieve the index of the selected combo list item for the last user selection in the case of the igCellCombo cells:

http://10tec.com/forum/p...th-style-igCellTextCombo 

This helper tool can be used through the DevDbg call with the parameter 3 like this:

Dim lListIndex As Long
iGrid1.DevDbg 3, lListIndex

It also works for combo item selection in the case of the igCellTextCombo cells. Perhaps, it will help you somehow.

Let me think whether this trick can be used for text editing for this type of cells.

Private Sub iGrid0_BeforeCommitEdit(ByVal lRow As Long, ByVal lCol As Long, eResult As Long, ByVal sNewText As String, vNewValue As Variant, ByVal lConvErr As Long, ByVal bCanProceedEditing As Boolean)
    Dim ListIndex As Long
    If Grd.CellType(lRow, lCol) = igCellTextCombo Then
        Grd.DevDbg 3, ListIndex
        If ListIndex = -1 Then
            If Not AddNewValueToCB(lRow, vNewValue) Then
                eResult = igEditResProceed
            End If
        End If
    End If
End Sub

Private Sub iGrid0_AfterCommitEdit(ByVal lRow As Long, ByVal lCol As Long, ByVal vOldValue As Variant)
    Dim ListIndex As Long
    If Grd.CellType(lRow, lCol) = igCellTextCombo Then
        Grd.DevDbg 3, ListIndex
        KeyToStore = Cb.ItemValue(ListIndex)
    end if

I have implemented this in a new interim build of iGrid and sent the link to download it to your mailbox.

One more thought about the functionality you need to implement:

• When a user selects a listed town, to store the ID in the database, developer must do a binary recursive search in Combo Box items (or loop) to find the corresponding Index of the displayed text, so that you can retrieve the ItemValue and store it.
• When user enters a new town, developer must do again a binary recursive search in Combo Box items to find if the town is listed. If not, new Town must be added to the database and repopulate the combo box to include the new value or must find by code the proper index to insert it.

You may think about finding these values directly in the recordset you used to populate the combo list. Perhaps, the recordset object can provide you with its own methods to find what you need.