Blank Lines

[OldManEd]

I have a report that includes a cell phone field as a separate line in the
report. It leaves a blank line when the cellphone field is empty. Is there a
way to skip this and avoid a blank line?

OMEd

 

[Evi]

Ensure that the Cellphone textbox has the Can Grow/Can Shrink Properties set
to yes. Do the same for the section containing this control (unless you are
making a label report)
Things that could stop this happening is an unattached label on the same row
as the text box (to attach the label, if it no longer moves when you move
the textbox, cut it, select the text box and paste it).

If you can't use CanGrow/Can shrink then you can use the On Format Event of
the Section to make the control invisible

eg

If IsNull(Me.CellPhone) Then
Me.CellPhone.Visible = False
Else
Me.CellPhone.Visible=True
End If

Evi