Search Memo Field

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
 
F

fredg

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?] & "*"
 
P

Peter McCartney

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...
 
Top