Searching a memo field.

[kwbonin]

I need to know if it is possible to search a memo field for a specific value. I have a situation where users will be entering a date range (if possible this woudl be preferred) or a single date (if possible), and using that entered value to search the memo field for a match.

 

[mark curtis]

In your query you could use something as follows:

like "*[yourdate]*"

But I would try to avoid relying on searching memo fields.

 

[Mile-O]

You can use the InStr() function.