G
Guest
I do appreciate this resource!!!
My report is a list of property files identified by control numbers (CN).
There are with 3 fields for each CN -- Description, Address, City.
Each of the 3 fields has a label.
I can make the label of an empty field invisible with code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
'Suppress label when field is empty.
Dim blnDescription As Boolean
'Determine if field is empty.
blnDescription = Not IsNull(Me.Desc)
'Set Visible property for labels.
lblDescription.Visible = blnDescription
End Sub
I have set the CanShrink property for the 3 fields to Yes.
I have set the CanShrink property for the Detail section to yes.
Access still leaves a blank line for an empty field.
How can I eliminate the unnecessary blank lines?
My report is a list of property files identified by control numbers (CN).
There are with 3 fields for each CN -- Description, Address, City.
Each of the 3 fields has a label.
I can make the label of an empty field invisible with code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
'Suppress label when field is empty.
Dim blnDescription As Boolean
'Determine if field is empty.
blnDescription = Not IsNull(Me.Desc)
'Set Visible property for labels.
lblDescription.Visible = blnDescription
End Sub
I have set the CanShrink property for the 3 fields to Yes.
I have set the CanShrink property for the Detail section to yes.
Access still leaves a blank line for an empty field.
How can I eliminate the unnecessary blank lines?