background color value

[mcat]

How do I access 2016 change background color based on value in another field?
not a text field
IE if kanban type is b/o blue if y yellow

 

[theDBguy]

Hi. Welcome to the forum! Have you tried using Expression Is in Conditional Formatting?

 

[pbaldy]

Have you looked at Conditional Formatting, on the ribbon?

FYI I'm going to move this thread to a more appropriate forum. Welcome to AWF!

 

[mcat]

Conditional Formatting is grayed out on background.
I think it only works with a text box.
I'm a newbe to Access

 

[theDBguy]

Conditional Formatting is grayed out on background.
I think it only works with a text box.
I'm a newbe to Access

Hi. I can't download your file at the moment. What control are you trying to change the color? Sometimes, you could use a workaround by using a Textbox to represent it, so you can apply conditional formatting.

 

[pbaldy]

Which control? You can make a textbox look the same as a label.

 

[mcat]

back color on the property sheet

 

[theDBguy]

back color on the property sheet

Of what/which control though? Are you talking about for the Form itself?

 

[isladogs]

Is the attached what you want? If so black text may be better when the background is yellow.
I used conditional formatting as previously suggested by others.

Strongly recommend your field names do not contain spaces or special characters

 

[mcat]

No I need box5 to change color with kanban type value in query.

 

[mcat]

I took out spaces in field names.
Thanks

 

[isladogs]

OK then - like this ? I hope so!

I've removed the previous conditional formatting from v2
To do the above I've had to use the Detail_Format event as CF can't be used on box controls
However that event only runs in print preview or when printed.
You won't see the effect in report view or layout view.
That cannot be done!

Hope that helps

NOTE: You should also remove special characters like / from field names