Question Locked

Dislplay only Access Report Details Section lines/rows when control = true

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

The detail section in my report correctly displays only the controls that are true using the visible feature. However, a blank line displays on the report. Is there a way to skip the control/line feed if the control value is false?

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

If Me.Deed = False Then

Me.Deed.Visible = False
Me.txtDeed.Visible = False

End If
If Me.IncomeProof = False Then
Me.IncomeProof.Visible = False
Me.txtIncome.Visible = False

End If
If Me.PictureID1 = False Then
Me.PictureID1.Visible = False
Me.txtPictureID.Visible = False

End If
If Me.TaxReceipt = False Then
Me.TaxReceipt.Visible = False
Me.txtTaxes.Visible = False

End If

1 reply

This discussion is closed to new replies.