Test if value is less than percent

Access Discussion in 'Microsoft Office' started by KWhiteDA, Apr 25, 2017.

  1. KWhiteDA

    KWhiteDA

    Joined:
    Apr 25, 2017
    Likes Received:
    0
    I have a report setup in MS Access 2013 that, in one of the fields, it calculates a percentage. The field is formatted using the Format() function as a percent.

    I want a warning sign (image) to display if the percentage falls below 10%.

    Here is what I I have so far in the Detail_Format() Sub:

    IF Me.PercentField <= .10 THEN
    Me.imgWarn.Visible = TRUE
    ELSE
    Me.imgWarn.Visible = FALSE
    ENDIF

    The image never displays
     
    KWhiteDA, Apr 25, 2017
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
Loading...