Search on memo fields

[StephenD]

Hi everyone,

I'd like to create a search form that searches and returns any records that contain the text that a user enters in a text box on a form-the form would be searching a memo field in a table-does anyone know if this is possible in Access??

Many Thanks,

SteveD

 

[ColinEssex]

Hi

Never actually done it on a memo field. But to start off an answer - I think you may have to use the Instr function.

I know that memo fields are stored differently to normal text fields not sure if this has any bearing.

Col

 

[Rich]

Why not use the built in Find / search method?

 

[Cosmos75]

Rich,

Do you mean the Ctrl-F (Find)? That should work, only have to remember that you must have the focus in the field you want to search.

 

[Opengrave]

It is possible and from my experience no different than searching text. I have a form (frm_Query) with a text box called Description. In the CRITERIA section of my query I have

Like "*" & [Forms]![frm_Query]![Description] & "*"

Basically it will find any record that has the text in the box anywhere in the Description field.