[AccessD] First Encounter With a Memo Field

Stuart McLachlan stuart at lexacorp.com.pg
Mon Aug 29 19:58:39 CDT 2011


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
> 






More information about the AccessD mailing list