problems with CanShrink

[jeeper987]

My report hides fields when they are null using this code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.MyField.Visible = Not IsNull(Me.MyField)
end Sub

I have enabled the CanShrink for each field in the report, but it still leaves some blank space where the excluded fields are. How can I fix this?

Also, is there a way to I can select all fields in the report with a single command instead of doing this :
Me.MyField.Visible = Not IsNull(Me.MyField)

for each field. Maybe something like:
Me.AllFields.Visible = Not IsNull(Me.AllFields)

Thanks in advance

 

[Rich]

Did you set the can shrink on the detail section as well.

 

[jeeper987]

yes I set it on the detail section and for each field individually and it still leaves some blank white space