I have a problem,  in my database that deals with film and Tv shows... I have titles for example:

"Star Trek episode # 12"  

the "#" really throws a kink in the search giving me NO RESULTS in my list box.  How do I get the search to recognize the "#" or any other non alpha/numeric character for that matter?

Also on some of my forms if certain fields are left blank because of no data available,  I notice they don't show up in the search as well.  why is that?

Thank you
Rick

---

Reply from Alex Hedley:

Since # is used for dates this will not work.
You'll need to surround the # with square brackets ( [ ] )

This goes for

• [ => [[]


• ] => []]


• * => [*]


• ? => [?]


• # => [#]

You can use the REPLACE function to change the string you enter before you pass it into your query.


Do you have an OR or an AND in your Query Criteria.
Are you checking for IS NULL?
OR - Down
AND - Across