Suppress blanks in Report

[kmacd6951]

I have a very basic report with one field per line.

Each field has it's properties set to YES for Can Grow and YES for Can Shrink - so that the text fills only the space it needs.
I have the properties on the DETAIL section also set to YES for Can Grow and Can Shrink.

I am still getting lots of chunks of white space for fields that are blank though.
There is nothing else formatted on each line, except the one field value.

What else could I be missing?

I want to only see text when something was entered - and not waste all this paper with the white spaces....

 

[Joe4]

I do something somewhat similar you may be able to apply to your problem. I have a report with many different Group Header sections. However, if the value of the field is zero, I want to hide that Group Header section altogether.

In addition to setting the Can Grow and Can Shrink properties to Yes, I also add the following code to the On Format event:

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)

If Me![AdminFee] = 0 Then
    Me.GroupHeader1.Visible = False
Else
    Me.GroupHeader1.Visible = True
End If

End Sub

Note: AdminFee is the name of my field.

You should be able to apply the same methodology to the Detail section.

 

[kmacd6951]

Hmmm...doesn't seem to be working for me (didn't change anything). I wonder if it is because my data fields are of data type 'memo' - so maybe when they are blank, it is not "0", but a different value?