VBA string concatenation question

[ntarikere]

Hi everyone!
I have a visual basic module written against access 97 database table. The purpose of the module is to concatenate few strings and update it back to the database column

The string variable is of type "String"

The database column is of type "Memo"

When I try to update the database column with the value in the string variable, I'm losing some part of the text at the end. This is not a size issue because I have noticed that a longer string is updating back to the database ok but I have problems with a shorter string.
For example
str1 = "aaaaaa" & "bbbbbb" & "cccccccc" is updating as

str1_in_the_database = "aaaaaabbbbbbcccccccc" (updating ok)

str2 = "ddddddd" & "eeeeeeee" is updating as

str2_in_the_database = ""dddddddee" (NOT OK)(losing some part of the text)

(debug.print on str2 looks ok too, so I don't know where exactly is the problem)

Any help is appreciated.
Thanks!
naren

 

[Rolliee]

Are you putting it in a field which is defined too short?

Rollie E