[AccessD] First Encounter With a Memo Field

William Benson vbacreations at gmail.com
Mon Aug 29 19:33:13 CDT 2011


How about reading all of them into a single string or a disconnected
recordset with some marker for the messageidID... and search that result
On Aug 29, 2011 8:28 PM, "Brad Marks" <BradM at blackforestltd.com> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list