Blank Lines

  • Thread starter Thread starter OldManEd
  • Start date Start date
O

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