Fredd
asked on
Full string not returned on RS.open command
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
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,
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
is there a line feed in the original text.
ASKER
I don't think so. It happens on several fields and they all display properly in a form
cri6comment is just one of them.
cri6comment is just one of them.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I discovered that the query wasn't returning the full text field. There are several situtations where a query will truncate a long text field - such as using DISTINCT with a long text field will truncate it to 255 chars). However, none of those applied to me.
I fixed the problem by copying the query from an old backup and it started working.
Whew...
I fixed the problem by copying the query from an old backup and it started working.
Whew...
ASKER
Thanks everyone -