Brad Marks
BradM at blackforestltd.com
Tue Aug 30 16:09:40 CDT 2011
All, Thanks for the help/advice on this problem. I am still struggling with this one. For testing, I have set up an Access report which I use to view the data in the Outlook Memo field. I then set up a number of tests of the InStr against a string field which I use to store the Memo field. The results are not what I was expecting. The Instr works for some of the values that I can see on the report, but not all of them. I don't know if the problem is in how the InStr works or in how Outlook is storing the Memo field. Maybe it is something else. I would guess that others may have tried to work with the Outlook "Contents" field and have run into similar issues. I am open to any ideas. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, August 29, 2011 7:59 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] First Encounter With a Memo Field Hove you checked the length of the string/field you are using INSTR on? If you apply any sorting/grouping function to a memo field in a query, you frequently only get the first 255 characters of the field returned. A common workaround is to do the sorting/grouping in a query which just returns the primary keys of the records you want in the order that you want them. Then use this query in another query that returns all the columns you want, including the memo field. -- Stuart On 29 Aug 2011 at 19:20, Brad Marks 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.