Hide multiple fields in report detail section if no data

[mkfloque]

Good Day All,

I 've figured out how to hide ONE field (called "WorkshopDeadline"):

********************************
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.WorkshopDeadline) Then
Me.WorkshopDeadline.Visible = False
Else
Me.WorkshopDeadline.Visible = True


End If


End Sub



********************************
But how do i hide more than one field?
Thank you!

[pbaldy]

You can repeat the If/Then/Else block for other fields. You might also check out the Can Shrink property.

[June7]

Are the controls arranged horizontally? Even though not visible, doesn't the control still occupy space resulting in blank area on report?

[mkfloque]

Thank you Paul. Do i need to open a new sub procedure? Or just place the code within the current sub procedure?

[pbaldy]

Thank you Paul. Do i need to open a new sub procedure? Or just place the code within the current sub procedure?

You can add to the existing sub:

If...
End If

If...
End If

[mkfloque]

Thank you Paul, solved!

[pbaldy]

Happy to help!