Hi,

I have an .adp connected to a SQL database. I've made a form with a TextBox
connected to a varchar(1024) in the SQL database. I am trying to use VB to
update this text box with the concatenation of text from other fields.

The SQL field, the Text box, and the strings from VB can all handle more
than 255 characters. But whan I use VB (triggered by a button on the form)
to update the text box, it fails if the combined text is longer than 255
chars.

In case it helps, the failure is a little odd... Instead of truncating when
255 chars is exceeded, this actually chops off the first 255 characters once
it is exceeded. So, under 255 works perfectly. But if I go over 255 by one
word, only that one word is put into the text box.

The function is:
  Function CombineStuff()
     TextBoxCombined = TextBoxSource1 & TextBoxSource2
  End Function

Can anyone suggest the reason for this (or better yet, a solution)
Thanks!