Hide Rectangle if field is null

[juniorz]

Hi,

I have a report that varies in length depending on how many records are placed in it. i want to add rectangles to neaten the records into tables, however if there are no records then i dont want the rectangle objects to show.

Is there a way i can hide rectangle if the field doesn't have a value?

 

[arnelgp]

if it is a print preview, do it in the format event of the detail section:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.[COLOR=Blue]Box1[/COLOR].Visible = Trim(Me.[COLOR=Blue]ControlNameToCheck[/COLOR] & "") <> ""
End Sub

 

[juniorz]

Thanks, i tried your code however I receive the following error:

"The expression On Format you entered as the event property setting produced the following error: Ambiguous Name detected: Detail_Format"

What did I do wrong?

 

[MarkK]

You added an event handler that already exists. Find the existing . . .

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

. . . and add the new code to the existing routine.