OK, I've got a strange one here...
I've got a report that has a bunch of figures & an optional comment field.
If I look at the underlying query I can see all the comments.
But when the report is produced, some of the comments don't show up
The textbox on the report is set to autogrow/autoshrink, but I don't think that's causing the problem.
(And it's under the row of figures, so it's not falling off the page or anything.)
I have tried concatenating the field value with other text, Trimming it, checking if it IsNull... still won't show up (for these specific records).
Could there be nonprinting characters in the field? First character null, so it thinks it's the end of the string? (but if so, why does it show up OK in the query? and how did it get there in the first place?)
I've got a report that has a bunch of figures & an optional comment field.
If I look at the underlying query I can see all the comments.
But when the report is produced, some of the comments don't show up

The textbox on the report is set to autogrow/autoshrink, but I don't think that's causing the problem.
(And it's under the row of figures, so it's not falling off the page or anything.)
I have tried concatenating the field value with other text, Trimming it, checking if it IsNull... still won't show up (for these specific records).
Could there be nonprinting characters in the field? First character null, so it thinks it's the end of the string? (but if so, why does it show up OK in the query? and how did it get there in the first place?)
Last edited: