I Have four memo fields in a form. While they are searchable in table view, I cannot get the same search to produce results in the form view. Does anyone know why this is? Better yet, does anyone have a suggestion as to making them searchable? I am using simple keyboard search with the usual wild cards.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
search memo in form?
- Thread starter jlockley
- Start date
- Thread starter
- #2
JUst in case anyone has the same problem, I have the answer. It doesn't make sense, but it works.
In order to search in memo fields, either formated or otherwise, advance pattern match must be checked.
Ergo
..Jeff Adams.. will not function in exact match, but will in advance pattern match. Go figure.
An odd note: Am I the only one who can work on a problem for five days solid, finally give up and run here for help (and thank you all), then find the answer as soon as the browser is closed? It's like the pain disappearing in the doctor's office.
In order to search in memo fields, either formated or otherwise, advance pattern match must be checked.
Ergo
..Jeff Adams.. will not function in exact match, but will in advance pattern match. Go figure.
An odd note: Am I the only one who can work on a problem for five days solid, finally give up and run here for help (and thank you all), then find the answer as soon as the browser is closed? It's like the pain disappearing in the doctor's office.
- Status
Similar threads
- Locked
- Question