Solved Conditional Formatting on Split Form (1 Viewer)

[marion34s]

Hello again Access Wizards,

I created some conditional formatting so that my users would be able to see at a glance when some of their project metrics were out of balance or almost depleated. I used the Conditional Formatting tool from the ribbon (seen below) to set it up but it does not work. I have deleted the conditional format and re-created it with no success. Any suggestions to correct my "mistake"?

Thanks!

 

[theDBguy]

Hi. Can you post a sample db with test data?

 

[Dreamweaver]

Try using an expression like [%HoursUsed]>=0.75 that is if you are useing a percent value if not use 75.
I did notice you have spaces in your field name(s) this is not recommended

 

[zeroaccess]

Try using an expression like [%HoursUsed]>=0.75 that is if you are useing a percent value if not use 75.
I did notice you have spaces in your field name(s) this is not recommended

But if you use [fieldname] all is well.

 

[Dreamweaver]

It's another one of those Access Quirks

Glade you got it working

 

[marion34s]

Try using an expression like [%HoursUsed]>=0.75 that is if you are useing a percent value if not use 75.
I did notice you have spaces in your field name(s) this is not recommended

Thank you MickJav! This did the trick!!