CanShrink

  • Thread starter Thread starter Jacob Frankham
  • Start date Start date
J

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
 
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
 
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
 
Back
Top