Blank space in Access reports

[Nancy]

When I create a report in Access 2003 using several
levels of sorting, I get 1 to 2 inches of blank space
between each sort level even though I indicate that the
level can be shrunk.

Does anyone have any idea how to eliminate the blank
space?

Thanks,


Nancy

 

[Evi]

Some things don't shrink, labels and lines don't seem to so if you have a
line in your section the section won't shrink past that line.

Check that not only the section but also that text box controls can grow and
shrink.

Anything with a formula in it, even if it comes to Null, won't shrink so put
your formulae in the report's query instead of in the report itself.

Also, if it contains "" rather than Null (this can happen when you import
records from Excel) it won't shrink.

Sometimes it works to make the controls invisible in the On Format Event of
the section eg

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtName = " " Then
Me.txtName.Visible = False
Else
Me.txtName.Visible = True
End If

If Me.Town = "None" Then
Me.Town.Visible = False
Else
Me.Town.Visible = True
End If
If Me.CntyAbbr = "None" Then
Me.CntyAbbr.Visible = False
Else
Me.CntyAbbr.Visible = True
End If



End Sub

Evi

 

[BR]

You can also shorten your code some by re-writing to
Me.txtName.Visible = Me.txtName = " "
versus
If Me.txtName = " " Then
Me.txtName.Visible = False
Else
Me.txtName.Visible = True
End If