Autofill like Google

[intefix]

Is it possible to have (like follow image...)

autofill- complete fields results in Access 2007?
Regards

 

[Minty]

Look at the auto-complete setting of a combo box. It doesn't do a full text search only the beginning characters.

A full text search as you type requires a significant amount of additional VBA coding.

 

[static]

Filtering isn't too difficult. Don't think you can highlight characters though.

edited. AutoExpand on makes things more difficult. Probably better to turn it off.

Private Sub Combo0_Change()
    f = Combo0.Text
     
    If Len(f) = 0 Then
        Combo0.RowSource = "select field from table1"
    Else
        Combo0.RowSource = "select field from table1 where field like '*" & f & "*'"
    End If
    Combo0.Dropdown
End Sub

Private Sub Form_Load()
    Combo0.SetFocus
    combo0.AutoExpand =false
    Combo0_Change
End Sub

 

[intefix]

That is ok...
But in my case we have Greek Characters Α ='Α=α=ά etc.
and maybe user write with mistakes... (use maybe soundex with greek code?)
Thanks