Microsoft KB Archive/96987

= ACC: Combo Box Displays Only 255 Characters of Memo Field =

Article ID: 96987

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q96987



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you are looking at the contents of a Memo field in a combo box, the entire contents of the Memo field are not visible. Instead, only the first 255 characters of the Memo field are visible.



RESOLUTION
If you need to view the entire contents of a Memo field, use a text box instead of a combo box.



STATUS
This behavior is by design.



MORE INFORMATION
Most data types are limited to 255 characters, but Memo data type fields can contain up to 32,000 characters. A combo box can display only up to 255 characters, regardless of the underlying field's data type.

