Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Vail, Colorado, USA
    Posts
    194
    Thanks
    36
    Thanked 0 Times in 0 Posts

    Show line in a report based on a control being visible

    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

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    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
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •