Mary Edwards
New member
- Local time
- Today, 14:56
- Joined
- Jun 17, 2020
- Messages
- 10
I am needing to conditionally format 16 textboxes but the perimeters may change.
We are looking at a RAG rating (Red, Amber, Green) currently red is <15 amber is >14 and <23 green is >22. However in the future we may want to move the boundaries, ie have red as <10. Is there a way of having this information stored and able to be edited that will subsequently change the formatting rules?
I have tried as below
I have a table where only 1 record is allowed then Expression is <"Table"!Red!
I have a query which is a sum of Red field in that table Expression is <"SumQuery"!Red!
I have a textbox in a form based on the table and tried <"Form"!Red textbox!
We are looking at a RAG rating (Red, Amber, Green) currently red is <15 amber is >14 and <23 green is >22. However in the future we may want to move the boundaries, ie have red as <10. Is there a way of having this information stored and able to be edited that will subsequently change the formatting rules?
I have tried as below
I have a table where only 1 record is allowed then Expression is <"Table"!Red!
I have a query which is a sum of Red field in that table Expression is <"SumQuery"!Red!
I have a textbox in a form based on the table and tried <"Form"!Red textbox!