Wildcard Expressions in Search Field

[eww]

Is there a way to turn these off? Or is there a way to work around them. I have a search field that works fine except for when the field it is searching has a # in it.



I realize that you can put brackets around it when you are searching and everything works fine but I'm trying to make it a little more user friendly so I was wondering if there is a way to disable the wildcard expressions and/or when the search field is entered, if it contains a #, replacing the text with whatever it was, except with [#] instead.

My last resort might just be disallowing a special characters like #,?,* to be entered into the field that is being searched, but I'm not sure how to do this either. This is only if the first two options are not doable though.

[weekend00]

you can replace the # in search string to [#], for example, in your table you have "abcd#a234" in a record, user input search string "*#a2", then you change search string to "*[#]a2" (you may use use replace(SearchStr,"#","[#]") ), and you can find the record.

Same for ?, *

[eww]

I think this is on the right track for what I want, but I'm still having some problems understanding it / implementing it. Here's what I have so far:

Private Sub cboProjectSearch_AfterUpdate()
Dim LResult As String
LResult = Replace(cboProjectSearch, "#", "[#]")
Me.txtProjectName.SetFocus
DoCmd.FindRecord Me.cboProjectSearch, acEntire
End Sub

[weekend00]

you did not use the LResult in the search command.

Please change
DoCmd.FindRecord Me.cboProjectSearch, acEntire
to
DoCmd.FindRecord LResult, acEntire

[eww]

Ah hah! There it is, thanks a bunch Weekend.