Search Memo Field

[cmiyatake]

I have Access 2016. I have imported a company spreadsheet as a table and created a query and form to which I may search the data. The key field that I need to gather data searches from is a memo field. How can I do searches on this field?

[ranman256]

a text box on a form, user enters the word in txtFind box,
the query would be:

select * from table where [myfield] like "*" & forms!myForm!txtFind & "*"

this should work in 2016 LONG TEXT field,
but may not work with the old MEMO fields. (back then you couldn't search in memo fields)

[cmiyatake]

many thanks. just what I was looking for.

[Micron]

I have imported a company spreadsheet as a table

Watch out for truncation on long text/memo fields, both in the import and any query results. Data can get cut off after 255 characters.