 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / October 2006Combo Box truncate data?
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 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. >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. [quoted text clipped - 4 lines] >any idea? >thanks Yes there is an ID field. However, It is interesting, why Microsoft does not fix this issu? Al > 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 [quoted text clipped - 13 lines] > >any idea? > >thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.