Full string not returned on RS.open command
Posted on 2016-10-20
Access 2013, desktop
A query called queryname returns the value of the field Cri6Comment among others.
When I run the query by itself - it returns the full length of Cri6Comment - so far so good.
Cri6Comment has about say 1000 characters
When i do the following
dim string1 as string
rs.open "Select * from queryname ", currentproject.connection, adopenstatic adlockreadonly
debug.print rs!Cri6Comment \
The value is it is truncated ( suspect to 255 chars)
When I do
String1 = rs!cri6comment
String1 is truncated from what should be the true value of Cri6Comment.
Why is the query truncating my field?
Cri6comment is Long Test