Ive made a search that wenn there's a table choosen. The combo box will fill with iths field and you can choose one and fill something in. The result shows in a list box. Wenn i double click on it it will goto a more detailed form.
The problem is that if there's something with dots in the text or ! it will give an error. Is there any way it will search for it.

This is the SQL part that gives the error

strSQL = strSQL + " AND " & Application.BuildCriteria(Me.List44.RowSource & ".[" & Me.List44.Column(0, i) & "]", fld.Type, Forms!dbsearch.lstResult.Column(i))

Then wenn Forms!dbsearch.lstResult.Column(i)=T.F.D.
it sais that its invalid.