Results 1 to 2 of 2

Thread: [RESOLVED] Access Report - Change Visiblitly dep. on data...

  1. #1

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Resolved [RESOLVED] Access Report - Change Visiblitly dep. on data...

    how can I make a label (data text field.. or whatever it is!) visible only if its not = 1

    tried
    VB Code:
    1. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    2.     Debug.Print Me.Item_Count.Value
    3.     If Me.Item_Count.Value = 1 Then
    4.         Item_Count.Visible = False
    5.     End If
    6. End Sub

    doesnt want to work...
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  2. #2

    Thread Starter
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Access Report - Change Visiblitly dep. on data...

    OMG.. no sooner did I post that.. I figured it out....

    gotta do bothsides

    VB Code:
    1. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    2.     Debug.Print Me.Item_Count.Value
    3.     If Val(Me.Item_Count.Value) = 1 Then
    4.         Item_Count.Visible = False
    5.         lblAt.Visible = False
    6.     Else
    7.         Item_Count.Visible = True
    8.         lblAt.Visible = True
    9.     End If
    10.    
    11. End Sub
    oh well
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

Posting Permissions

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



Click Here to Expand Forum to Full Width