CanShrink

[Jacob Frankham]

Hi

I am using the CanShrink property on textboxes in a group called office.

Basically, if the textboxes in this group are Null then I dont want them
shown (which I have catered for using an Iif statement) and I have set the
CanShrink property of all the textboxes (and the header) to YES

But I can still see a gap where the 'omitted' record used to be !!

Any ideas

Would be appreciated

Cheers

J

 

[SA]

Jacob:

If all values for the row of detail are null, then the way to skip the line
entirely is to use the .PrintSection property of the report as in:

If Me!Control1=0 and Me!control2= 0 Then
Me.PrintSection = False
Me.NextRecord = True
Else
Me.PrintSection = True
Me.NextRecord = False
End if

 

[Fons Ponsioen]

You can also set the property for band wherin the
textboxes are to can shrink yes, and I think that will
correct your problem.
Fons