[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:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    Debug.Print Me.Item_Count.Value
    If Me.Item_Count.Value = 1 Then
        Item_Count.Visible = False
    End If
End Sub

doesnt want to work...

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

gotta do bothsides

VB Code:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    Debug.Print Me.Item_Count.Value
    If Val(Me.Item_Count.Value) = 1 Then
        Item_Count.Visible = False
        lblAt.Visible = False
    Else
        Item_Count.Visible = True
        lblAt.Visible = True
    End If
    
End Sub

oh well