>is the memo field searchable? We want to use it to record
>notes, and we want to search the notes in the future by
>keywords...
Certainly. You cannot put an index on it, so the search may be slow if
you have a lot of records and/or a lot of text in the memo field, but
a Query like
SELECT * FROM MyTable
WHERE memofield LIKE "*zebra*"
will find all the records containing zebra in the memo field.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public