Can Shrink property is shrinking text boxes with data present

[Skip]

I have a report that includes five rows of different text boxes in the Detail
section. Each of the five text boxes are different and separate data
elements in the source table.

Ex: aaaaaaaaa
bbbbbbbbb
cccccccccc
ddddddddd
eeeeeeeee

Data may exist in any or all five fields. When I set the Can Shrink to Yes,
it collapses the null fields just fine. The problem I'm having is it is also
collapsing some of the other fields with data present, not allowing it to
display the data on the report. I'm at my wits end on why this will not work
properly. Ideas? Suggestion?

I appreciate any feedback!

 

[Wayne Morgan]

If you haven't accidentally set something else, such as Hide Duplicates, and
aren't doing anything in code to cause this, then the basic answer is "it
shouldn't be doing it". This usually means that something is corrupted. Have
you tried deleting and recreating the offending textboxes? If that doesn't
work, there may be a work-around. You can concatenate the string, inserting
carriage returns and using the fact that Null will propagate through a
mathematical expression.

Example:
=[Field1] + (Chr(13) & Chr(10)) & [Field2] + (Chr(13) & Chr(10)) & [Field3]
+ (Chr(13) & Chr(10)) & [Field4] + (Chr(13) & Chr(10)) & [Field5]

This works if the fields are text. I've had problems getting it to work with
other data types, even if I use CStr().