Show line in a report based on a control being visible

Topic

New Reply

I have three groups in a report and I want a line after the end of each group. The first control I set duplicates to no. The second and third I use an expression to sir press them if the prior control is not visible and insert a null value if not. I have tried putting in a footer for each group that works but repeats the previous controls. I have tried removing the footers and showing the line programmatically

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
‘If txtpad.IsVisible Then
If txtpad.Value = Null Then
Line49.Visible = True
Else
Line49.Visible = False
End If
End Sub

any suggestions greatly appreciated

Peter

Reply | Quote

Replies

NULL is not a value. Rather it is the absence of a value.
So you can’t say: If txtpad.Value = Null Then

rather you need to use
If isNull(me.txtpad) Then

Reply | Quote