Filtering on textbox than contains ampersand

[dotNet]

I have a company field in my database and a corresponding textbox on my form. I know there is a company named T&P in the database.


When I right click, go to "text filters", then "contains", then type T&P in the filter box, no records come up. I tried entering it as T&&P in the database, that didn't work.

I also noticed that when I right click in the textbox on the form, the suggested filters say TP.

Any suggestions would be greatly appreciated.

[Stingaway]

What happens if you use a wild card and put in something like T?P

You may want to put a space after the P to ensure that something like "Tipton" doesn't show up...

[Stingaway]

Also, you could try Microsoft's "Workaround" approach, which is classic - more found at http://support.microsoft.com/kb/826763:

To work arond this problem, do not use special characters. If you must use special characters in query expressions, enclose the special characters in brackets ([]). For example, if you want to use the greater than sign (>), use [>].

[dotNet]

Thanks for the help. The wildcard solution seems to work. Now the hard part is to get my users to remember it.