Conditional Formatting - compare to other records has 2cm bar even when value 1 (1 Viewer)

bignose2

Registered User.
Local time
Today, 16:29
Joined
May 2, 2010
Messages
219
Hi,

Trying for graphical representation to show a level depending on values.
e.g. I have a table and the values will vary from 1 to 50.

I have the textbox set up with conditional formatting using compare to other records so as to get the fill in bar chart effect.

Trouble is the bar is already extended some way in when the value is 1.
I would expect just the thinnest bar when 1 but is at least 2cm

I have set tried CF with ..
low number 1, high number 50
left as low & high and the data has 1, 25 ,50

they all start off with the 2cm extra but I would really like if value 1 at a glance to see that it is the lowest.
I could somehow hide using a rectangle or something else but this just seem wrong.

Any idea's. Is this the way is it or just me?
 

Attachments

  • AccessCFNot1.pdf
    31.9 KB · Views: 125

theDBguy

I’m here to help
Staff member
Local time
Today, 09:29
Joined
Oct 29, 2018
Messages
21,358
Hi. It seems the width of the bar is dependent on the width of the control. If you go to Design View and make your control narrower, the width of the bars will also be narrower.
 

Users who are viewing this thread

Top Bottom