Hi, always helpful here, thx
I have a report that I want to change all the fields when ever the field name is matched.
field-name - Move Request
desired result, change to yellow if (value) ="Move Request"
I can do one of these using the conditional format tool but I want all the other fields to change as well.
Where would I use the expression, On Open or On Load and what is the color code to use?
I tried #FFF200 and vbyellow to no success
I have written this before with no issue in MS Access 213 but the 2016 version is different.
I have a report that I want to change all the fields when ever the field name is matched.
field-name - Move Request
desired result, change to yellow if (value) ="Move Request"
I can do one of these using the conditional format tool but I want all the other fields to change as well.
Where would I use the expression, On Open or On Load and what is the color code to use?
I tried #FFF200 and vbyellow to no success
I have written this before with no issue in MS Access 213 but the 2016 version is different.