I am trying to write an SQL statement that will search for specific characters(that are entered by the user) in a text field

Eliza,

assuming you want to use a dialog screen in which the user can enter the characters:

SELECT *
FROM YourTable
WHERE YourTableField LIKE "*"&[Enter characters]&"*"

RV