Memo Search

[PeterM]

I am trying to setup a listbox that searches a memo field in a table. I
create the SQL in VBA and then set the rowsource to the created SQL. They
all work fine except for the find within a memo field.

SELECT Appointments.*
FROM Appointments
WHERE Appointments.AP_Comments like '%REHAB%';

Is there something special when working with a memo field?
What am I doing wrong?

Thanks for your help!

 

[Arvin Meyer [MVP]]

VBA doesn't use the % sign for a wildcard, it uses the asterisk:

WHERE Appointments.AP_Comments like "*REHAB*";

 

[Steve]

Maybe you should consider a revision to your tables! If you are storing data
in a memo field, that data should be stores in a table. Memo fields are
99.99% of the time used for notes.

Steve
(e-mail address removed)

 

[PeterM]

Thank you very much Arvin.

VBA doesn't use the % sign for a wildcard, it uses the asterisk:

WHERE Appointments.AP_Comments like "*REHAB*";
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com




.