Results 1 to 3 of 3

Thread: Visible (2003)

  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Visible (2003)

    Grrrrrr......... <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    <pre>Private Sub Form_Current()
    Me.cboUnitNumber.Requery
    If [memBillingPublic] Is Null Then
    Me.curMiscCharge.Visible = False
    Else
    Me.curMiscCharge.Visible = True
    End If
    End Sub</pre>

    I'm trying to hide curMiscCharge until an entry is made in memBillingPublic, but getting a VBA "object required" error (#424).
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Visible (2003)

    You must use the IsNull(...) function instead of ... Is Null. Try

    Private Sub Form_Current()
    Me.cboUnitNumber.Requery
    Me.curMiscCharge.Visible = Not IsNull(Me.memBillingPublic)
    End Sub

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Visible (2003)

    Easy for you to say <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    I swear, every time I think I know what I'm doing I find it's only a lesson in humility.
    Thank you Hans!
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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