Re: Searching text in memo fields of Access 2003

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 12/07/04 

Date: Tue, 07 Dec 2004 17:52:36 -0600

David wrote:
>I would like to know if it is possible to search for specific text within
>memo fields of Access 2003 databases?

Yes. Use the Like operator along with wildcards, something
like:

SELECT *
FROM thetable
WHERE memofield Like "*specific text*" 

-- 
Marsh
MVP [MS Access]

Relevant Pages

  • Re: Cursor doesnt select text correctly
    ... >letters and then several spaces after that. ... >examplee sentence. ... >This happens in several of my databases in the memo fields on a form, ... >Also in other databases I use in the memo field. ...
    (microsoft.public.access.forms)
  • Re: Move SQL databases?
    ... OK thank you David ... > Page 14 beings dicussing moving the SBSMonitoring database. ... >> I checked the whotepaper but it does not cover SQL databases. ...
    (microsoft.public.windows.server.sbs)
  • Re: On Subject: Navigation Systems
    ... David M. wrote: ... and etc. because the databases are not perfect. ... but still lots of mistakes. ... And almost all the GPS Points of Interest are derived from the same database. ...
    (rec.outdoors.rv-travel)
  • Re: Size of memo fields
    ... Doug Steele, Microsoft Access MVP ... (No private e-mails, please) ... "David Cleave" wrote in message ... > thinking of changing them to memo fields, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access Developer Handbook Question
    ... "David" wrote in message ... Is this a reference library problem? ... is there a standard set of reference library's I ... > off on new databases, is there a standard set of things I ...
    (microsoft.public.access.setupconfig)