Data Connectionshttps://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)Re: Searching a text field in Access for specific wordhttps://www.infopathdev.com:443/forums/thread/12402.aspxWed, 04 Apr 2007 14:36:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12402B.Shiva Prasad0https://www.infopathdev.com:443/forums/thread/12402.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12402Hi DonaldRLongII,<br /><br />Do like this, take a text field and a button. Apply a rule on the button by double clicking -&gt; Add -&gt; Set Condition.<br /><br />In the first combo box take field1 and 2nd combo box take contains and in 3rd combo box select text and type you text and click ok.<br /><br />After that click Add Action Button and apply an action what ever you want.<br /><br />Hope this will help you. If you want more details let us discuss.Searching a text field in Access for specific wordhttps://www.infopathdev.com:443/forums/thread/12168.aspxWed, 28 Mar 2007 14:52:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:12168DonaldRLongII0https://www.infopathdev.com:443/forums/thread/12168.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=12168Normally I would do a contains query if just in access, but using InfoPath I am not sure how I can submit a query that operates like contains. I need to be able to find certain words or phrases that might appear in a cell.<br /><br />Any thoughts?