ACC: Combo Box Displays Only 255 Characters of Memo Field

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

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:

Q93138 ACC: Using Column Property of Combo Box to Update Text Box

Keywords          : kbusage FmsCmbo 
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: March 20, 1999