Question
September 14, 2007 at 08:31 AM
dwlightsey

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

by dwlightsey . Updated 19 years, 1 month ago

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

This discussion is locked

All Comments