To search text within the Description field, you need the InStr() function.  For instance, the SQL below:

     SELECT * FROM ChronicleT WHERE InStr(1, Description, "book") <> 0

will return records where the Description field contains the text "book" somewhere in it.  Words with partial text "book" (e.g. Facebook, books, booked, etc.) will also be included.  It looks for exact matches of the text (spaces and other special characters included), so misspellings will be a problem.

Kevin, do I add that SQL script in the Description field Criteria?

Or is that VBA code in the form?  I don't understand how to apply that SQL.

On your first picture, under "View" at the top left, click that V-shaped button to open up the SQL screen, where you type the SQL statement (correct my misspelling first).  There are other issues to consider too.  My SQL above only searches for "book."  To allow your users to specify any search words, it takes more work.  One way is to create a "parameter query" that accepts user inputs.  Another is to use VBA code to get user inputs and construct the SQL statement.  I don't know your level, so refer to Richard's courses.  I've never taken any of his courses, so I would defer to Richard and others regarding what courses you need to do all of the above.

A couple of the videos Kevin might consider valuable for you are:

Parameter Query
Direct SQL View

I've never used SQL, so I will check out the videos.

You don't need SQL or VBA for a simple search like this. In your query design grid, under the Description field's Criteria row, enter:

Like "*book*"

That will return all records where Description contains the word "book." If you want to find records that don't contain it, add Not:

Not Like "*book*"

The asterisks are wildcards, meaning "anything before or after this text." So Like "*Smith*" finds descriptions containing Smith anywhere in the field.

Later, if you want the user to type in whatever word or name they are looking for, you can turn that into a parameter query. But start with the simple criteria first.

So Richard, I can search a name such as Like "Thomas"?  For that matter, any subject matter, such as Lime "Main St".?

Another simple route is using a text filter on a field in regular query view (pictured below), no need to go into design view.  This works in tables too.

Thank you all for the great recommendations.

You're very welcome. And yes, for a contains search you need the wildcards:

Like "*Thomas*"

or:

Like "*Main St*"

Be careful not to type "Lime" - it should be Like. Without the asterisks, Like "Thomas" only finds fields that contain exactly Thomas and nothing else. With the asterisks, it finds Thomas anywhere in the Description, such as "Letter from John Thomas" or "Thomas family history."

Kevin's filter suggestion is also handy for quick, one-time searches while you're viewing records. For a saved query that you can run again later, I'd use the criteria in the query design grid.

I like likes and lime juice, but yes to not typing Lime.  My High School typing teacher would be so disappointed.