CanShrink Property

[JPritch]

I am trying to eliminate the vertical space for null fields in my report using the CanShrink property.

I have set the CanShrink properties to YES for all fields and for the section where the fields lay.

However, the space is not shrinking. The labels are on the same line as the text boxes, and I even tried removing the labels, but the fields are still not shrinking. I have also made sure there are no lines in the section that could be interfering with the CanShrink property.

Any ideas on what might be wrong?

 

[JPritch]

I figured this one out, so I thought I'd post up a solution in the event anybody runs across a similar situation and does a search in the future:

The fields being pulled in the report were calculated fields of type If/Then from a query. Ex: (CalculatedFld: If [fieldx] = y,"text", " ").

As you can see, instead of using Null, I was using " ". Apparently, the " " is a value which was preventing the CanShrink property from shrinking the field. I switched all the " " to Null, and the CanShrink property began to work!!!