That's pretty disappointing news.. I want the "#" in the title.  Is it possible, based on the search seminar SQL VBA setup" to take a "SearchTerm" and say

if a "#" exists then S= SearchTerm &"["&"]"   something like that else S=SearchTerm.  

something like that because I don't want to upadate querry and remove it from the title?

PS I based if my search form on Product search lesson in the search seminar

---

Reply from Alex Hedley:

You can keep the # in your Field in the Table, I meant you would need to wrap the # in [] when passing it to the search function.

Just need to sanitise the search term before using it.
SearchTerm =REPLACE(SearchTerm, "#", "[#]")