Recordset truncating after 255 character

[selvakumar.arc]

Hi All,

I am trying to load the data from excel sheet to user forms based on some condition (like ID=101) and I am using recordset for this purpose. I am getting all the data from the excel sheet but the problem here is, in some of the field has more than 255 character and the values are truncating after 255 character. When I am checking its length then I am getting the correct count but when I am printing it into text box then it is displaying only 255 character.

I tried several ways to fix this issue like splitting the data into 255 character each but the problem here is it displays the first 255 character data correctly and remaining will come as blank/empty.

Can any one help me to fix this issue?



Thanks
Selvakumar R

[June7]

So the data imports correctly into a Memo type field? It should display properly in a textbox bound to that field.

If you want to provide db for analysis, follow instructions at bottom of my post.