How do I copy a string buffer of more than 255 characters into an Access 2003 TextBox
Posted on 2009-04-16
I have a situation where I am reading text from several Access database memo fields into several VBA strings. Then, depending on other conditions, I am setting the an unbound TextBox.Value to one of the VBA strings for user edit.
All works fine as long as the original string is 255 characters or less. However, if the string buffer I am attempting to copy is longer than 255 characters, strange things happen ... usually it just truncates the text in the textbox to 255 characters.
This is not a problem with a bound textbox ... only when attempting to set a TextBox value directly from a string longer than 255 characters.
I have found other solutions for Excel, but the outlined methods and functions (i.e. Character and Insert) are not available in Access VBA.
Does anyone know a work around?