Access - Search for names containing specific characters

August 2016


My application must show all names containing the following two letters IS. What criteria should I put in the Name field?


  • Use "* IS *".
  • Access will search for names containing characters between the 2 stars symbol.

See also :

This document entitled « Access - Search for names containing specific characters » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.