I am actually using conditionnal formating to change the background color of a field, id like to know if it is possible to change the background color of all the fields in a record based on the value of one field?
You're "using conditionnal formating to change the background color of a CONTROL" ( not a field )
What you really mean to ask is possible - but you need to set the conditional formatting on each control - just using the value in the first control as the parameter.
Set the Condition to "Expression Is" and use the control name ( with [ ] brackets ) in the expression box.
i dont know why you call a field( or text field) a control since its passive in a report though, is it how Microsoft calls it?
YES
Fields are found in TABLES and they hold data
The things that appear on Forms and Reports that make the data visible are CONTROLS
You can have a Field ( in a table ) with exactly the same name as a COntrol ( on the form ). It is, in these cases, vital that you have a clear understanding of which you are dealing with - because there are many instances where you treat one differently to the other.
Also, in the contract of these boards, in getting one's mind around someone elses problem it is a great help if they use the correct terminology - else a lot of time can get wasted solving the wrong problem.
( - Just to add confusion - if you display a form in DataSheet view { appears like you are looking directly at the table } then the cells that you see are called FIELDS. ( Welcome to the wonderful world of Microsoft ! ))
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.