Frothingslosh
Premier Pale Stale Ale
- Local time
- Yesterday, 20:53
- Joined
- Oct 17, 2012
- Messages
- 3,276
Okay, I'm stumped.
Is there any way to display more than 255 characters in a combo box? This is for Access 2016, for what it's worth.
The reason is that in an application I inherited, there is a method for users to update the 'Comments' field on multiple records at once. During this update process, a form is opened, then a front-end table is populated with all comments used in all records assigned to this recovery. (Ultra-quick info: A recovery is a group of records being reviewed that are all grouped together in some way. The grouping criteria are rather arbitrary.) These comments can range from a quick '1/3/19 - Outside filing limits' all the way up to a small novel - the field behind them is a SQL Server varchar(2000) field, which Access reads as LongText.
What's happening is that when a comment is over 255 characters in length, it's truncated at 255. The table contains the entire comment, no matter the size. The query behind the combobox passes the entire comment. The combobox itself, however, never shows more than 255 characters.
I even tried building a value list instead of using a query, and got the same result.
Is this just a case where I'm SOL due to engine limitations?
Is there any way to display more than 255 characters in a combo box? This is for Access 2016, for what it's worth.
The reason is that in an application I inherited, there is a method for users to update the 'Comments' field on multiple records at once. During this update process, a form is opened, then a front-end table is populated with all comments used in all records assigned to this recovery. (Ultra-quick info: A recovery is a group of records being reviewed that are all grouped together in some way. The grouping criteria are rather arbitrary.) These comments can range from a quick '1/3/19 - Outside filing limits' all the way up to a small novel - the field behind them is a SQL Server varchar(2000) field, which Access reads as LongText.
What's happening is that when a comment is over 255 characters in length, it's truncated at 255. The table contains the entire comment, no matter the size. The query behind the combobox passes the entire comment. The combobox itself, however, never shows more than 255 characters.
I even tried building a value list instead of using a query, and got the same result.
Is this just a case where I'm SOL due to engine limitations?