Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    41

    Unanswered: Currency Value 0.00 how to hide

    Someone please help me with this,

    I have a form with a currency field, if it shows 0.00 i want to hide it..

    whats the easiest way to do that?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Hide the control, you mean?
    Code:
    Private Sub Form_Current()
    
        If Nz(IsNull(Me.Amount.Value), 0) = 0 Then
            Me!Amount.Visible = False
        Else
            Me!Amount.Visible = True
        End If
    
    End Sub
    Where Amount is the name of the control.
    Have a nice day!

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    If you simply don't want to display zeros, you can also use the format property of a textbox. For numeric fields, it can have four parts, one of which is zero values.
    Paul

Posting Permissions

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