Search on memo fields

StephenD

Registered User.
Local time
Today, 21:20
Joined
Nov 23, 2001
Messages
38
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
 
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
 
Why not use the built in Find / search method?
 
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.
 
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
Code:
Like "*" & [Forms]![frm_Query]![Description] & "*"
Basically it will find any record that has the text in the box anywhere in the Description field.
 

Users who are viewing this thread

Back
Top Bottom