Search Engine for a Memo Field (AND NOT OR etc)

[DubaiDave]

Hello All,

My dB includes a very large number of comments made on documents. These are stored in a memo field.

My form allows a User to search for a word or string of words in the memo field by typing these into a form textbox and then this is applied to a query:

Like "*" & [Forms]![fmViewer]![txtSearchText] & "*" or IsNull

A subform is then lists all records with say "Foundation" or "Foundation Material" in the memo field.

Now I would like to add the ability for some more versatile sorting with logical operators. Thus I would like the User to be able to enter in my search textbox:

(Foundations AND Concrete) NOT Bricks

And this would return all records with..well I guess as above...in the the memo field.

I have searched for an hour, but found nothing. Can anybody point me in the right direction for some VBA code / example dBs?

DubaiDave (weekend developer)

 

[marianne]

if I were you, I am not going to make any memo data fields on my database. I have read somewhere that it is one of the causes of database corruption.