Combo Box truncate data?

[Guest]

I have a combo box on a form. The combo box looks up data in a memo field
(RowSource) to place it in the (contro source) which is also a memo field.
what happen is that when the user makes the selection, the text gets
truncated exactly at 255 char. even though, the user can copy and past the
entire text in the field and it will be no problem. the truncation only
happens when the combo box is used?
any idea?
thanks

 

[kingston via AccessMonster.com]

Do you have a record ID or something else that you can use in a query or
subroutine to copy the data directly? Hopefully, you're copying from and to
tables within Access. Exporting memo fields will also reveal this limit and
there isn't an easy way around it AFAIK. In any case, you can make the combo
box return the record ID, and with its AfterUpdate event, run an append query
to copy the field. Otherwise, if there isn't a record ID, let the combo box
do its thing and then run an update query using the first 255 characters to
find the original record.

 

[Guest]

Yes there is an ID field. However, It is interesting, why Microsoft does not
fix this issu?
Al