VBA String Limit - Stack Overflow

VBA strings can be more than 255 chars. A possible culprit is how the column is declared in your table.... Is the Comments column declared as varchar(255)? From the help file: A variable-length string can contain up to approximately 2 billion (2^31) chara

stackoverflow.com