Vanishing text fields...???

Adeptus

What's this button do?
Local time
Today, 16:38
Joined
Aug 2, 2006
Messages
300
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 :confused:

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:
Solved...
The comments textbox had Hide Duplicates = Yes
so any time there were 2 (or more) consecutive records with the same comments, only the first would show.

(Why the hell was this ticked in the first place? I hate maintaining other people's code...) :mad:
 

Users who are viewing this thread

Back
Top Bottom