Is there a way I can compare texts strings enter from a user at run time to an Access mdb field declared as memo? If there is a way, would anyone share it with me? The texts typed from a user at run time are from a text box compare to a SQL query from the Access mdb file. If that is not possible, please suggest another way that the comparison can be done with a more relaxed comparison. I have used the operator "=" and it is too strict and exact.

Please help if anyone have an idea.

Many thanks in advance!

Chong