If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Truncation of memo fields in SELECT queries - Access 2002
After an extensive search of the MS knowledge base, I still can't find an
answer: I have a simple SELECT query joining two tables, and I use the query as the data source for a form. One of the tables contains memo fields that I want to display on the form. I have the "Unique Values" property set to "Yes" to avoid getting duplicate results. When I run the query, the memo fields are truncated at 255 characters. This only happens when the "Unique Values" property is set to "Yes". I know that Access will only use the first 255 characters of a Memo field to do comparisons for a Parameter query, and the "Unique Values = Yes" setting does cause internal comparisons to take place when Access runs my SELECT query, even though it's not a Paramater query. However, I've found nothing that says memo fields will be truncated in the result set in any scenario! Is there a way around this? Or is it an "undocumented feature" of MS Jet . . . (Using MS Jet version 4.0.6218.0) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Top 20 and bottom 20 values | Brian Camire | Running & Setting Up Queries | 9 | January 8th, 2005 01:36 AM |
BUG: Using GROUP BY in query expression on MEMO fields it truncates data in MEMO fields to first 255 characters | [SolarAngel] | General Discussion | 5 | December 7th, 2004 06:29 PM |
BUG: Using GROUP BY in query expression on MEMO fields it truncates data in MEMO fields to first 255 characters | [SolarAngel] | Running & Setting Up Queries | 5 | December 7th, 2004 06:29 PM |
memo field truncation: new problem | whincup | Running & Setting Up Queries | 2 | November 16th, 2004 08:40 AM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |