ACC: Combo Box Displays Only 255 Characters of Memo Field (96987)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
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.
REFERENCES
For more information about how to update text boxes from a list box or
combo box, please see the following article in the Microsoft Knowledge
Base:
93138 ACC: Using Column Property of Combo Box to Update Text Box
| Modification Type: | Major | Last Reviewed: | 5/9/2003 |
|---|
| Keywords: | kbprb kbusage KB96987 |
|---|
|