Search Memo Field

  • Thread starter Thread starter Peter McCartney
  • Start date Start date
P

Peter McCartney

Hello All! Access 97, Thanking anyone for a response!

How do I search for specific text in a memo field and display those records?
Have searched google and microsoft but negative result.


Peter McCartney
 
Hello All! Access 97, Thanking anyone for a response!

How do I search for specific text in a memo field and display those records?
Have searched google and microsoft but negative result.


Peter McCartney
Click to expand...

In a query?
As criteria for the [MemoField] , write:
Like "*" & [Find what?] & "*"
 
Works Great & So Simple, Thank you!!
Peter


fredg said:
Hello All! Access 97, Thanking anyone for a response!

How do I search for specific text in a memo field and display those records?
Have searched google and microsoft but negative result.


Peter McCartney
Click to expand...

In a query?
As criteria for the [MemoField] , write:
Like "*" & [Find what?] & "*"
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restoring line breaks in memo field 1
Search text/memo field 3
Notes table and IndirectDataInput / Date stamp in Memo field 3
Problem with memo field 1
Microsoft Access HTML Viewer 8
Key Word Search in a memo field - How To? 7
Problem showing memo field in list box 3
Text box bound to Memo Field 1

Back
Top