View Full Version : Max number of characters


dgkindy
01-16-2008, 06:07 AM
I have a form with a textbox that is to display PO text. Number of character is in excess of 255. The textbox is unbound and it populated with the use of a string variable. The string length has not been defined. The recordset does contain all the details.

The problem is that when the field is populated, the PO text is truncated and only displays part of the text. Are Textboxes limited to the number of characters that can be displayed?

KenHigg
01-16-2008, 06:11 AM
May this will help (a little?)

http://allenbrowne.com/ser-63.html

andrey_anikin
09-03-2008, 03:34 AM
I have a similar problem: when I try to save a new record in a table with one field (Memo) containing more than 255 characters, the text to be saved to that field gets truncated to 255 symbols. The textbox where the text is typed is unboud; I use an INSERT query to adda new record to the table. Have gone through the info at the site offered by KenHigg, but it doesn't cover my case - it only speaks about UNION queries. Can anyone offer a clue?