Search Memo Field

[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

 

[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

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

 

[Peter McCartney]

Works Great & So Simple, Thank you!!
Peter

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

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