I am working on code to filter reco

[weightinwildcat]

I am working on code to filter records for display on a list box. In a few cases, the text field for product codes has the symbol'#' as the first character. Any thoughts on how to filter for this, since this is a special character?

 

[dhookom]

You should be able to replace the # with [#] like:

Private Sub txtFind_AfterUpdate()
    Dim strValue As String
    strValue = Replace(Me.txtFind, "#", "[#]")
    Me.lboName.RowSource = "SELECT tblTest.ID, tblTest.ShortText FROM tblTest WHERE ShortText Like """ & _
        strValue & "*"" ORDER BY tblTest.[ShortText];"
End Sub

Duane
Hook'D on Access
MS Access MVP