Access Test if value is less than percent

Joined
Apr 25, 2017
Messages
1
Reaction score
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
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top