[AccessD] First Encounter With a Memo Field

Brad Marks BradM at blackforestltd.com
Mon Aug 29 19:20:04 CDT 2011


In my work with Access so far, I have never had to deal with a Memo
field.

Recently a need has surfaced to work (in Access 2007) with an Outlook
Email field called "Contents" which is a Memo field.

I need to search through approximately 30,000 Emails for specific
strings in this Memo field.

>From my initial tests, it appears that the InStr Function does not work
with this Memo field.

Is there a way to find a specific string in a Memo field?

Thanks,
Brad




More information about the AccessD mailing list