conditional formatting (1 Viewer)

[quest]

hi,
I have a problem. My fields with conditional formatting are lighter then other fields look l ike they are selected. here i will send a screenshot. can someone tell me how to fix it.

 

[CJ_London]

need to clarify what you mean - are you talking about the non red date in the new record row? Or something about the third row? Whichever it is you need to provide a copy of what your rule is and what field(s) it applies to together with an explanation of what the rule is supposed to do

 

[quest]

need to clarify what you mean - are you talking about the non red date in the new record row? Or something about the third row? Whichever it is you need to provide a copy of what your rule is and what field(s) it applies to together with an explanation of what the rule is supposed to do

See the field where string "N/A" is red that is formatting if this field is equal to "N/A" then make it red. i think is not about formatting but something about back color. when i delete formatting white back color disappear and the filed is blue like other fields (in the record where cursor is).

 

[theDBguy]

See the field where string "N/A" is red that is formatting if this field is equal to "N/A" then make it red. i think is not about formatting but something about back color. when i delete formatting white back color disappear and the filed is blue like other fields (in the record where cursor is).

My guess is that when you assign a fore color using CF, you basically are also assigning a back color as well. I guess the default color is white. If you select a different back color, you'll see the same effect as you're getting now with white.

 

[CJ_London]

Whichever it is you need to provide a copy of what your rule is and what field(s) it applies to together with an explanation of what the rule is supposed to do

 

[quest]

My guess is that when you assign a fore color using CF, you basically are also assigning a back color as well. I guess the default color is white. If you select a different back color, you'll see the same effect as you're getting now with white.

When i write formatting i only choose red font color i don't touch background color. i tried even to put background color to automatic no effect. i don't know if i need to use background color which to use so there is no contrast and can be like other colors where is no formatting.

 

[quest]

rule don't matter. it is not wrong it do what should. something is mixed with colors. background colors i think is problem. don't know how to choose correct one. it is supposed to work when you change nothing. default should be same like other fields color.

 

[CJ_London]

If you say so - they don’t matter, so I’ll drop off this thread because i think that is where the problem is

Good luck

 

[quest]

If you say so - they don’t matter, so I’ll drop off this thread because i think that is where the problem is

Good luck

I tested this many times. i gave you before simple formatting example. i have different formatting for many fields and they all work (i mean execution they turn text red). problem is that background color is different from the fields that don't have formatting. they should be uniform. all to have same color.

 

[GPGeorge]

Hi, there might be a slight language problem. We do not need to see a screenshot of just the result.

We also need to see a screenshot of the form in design view showing us the actual rule you wrote for the conditional formatting. That's where the problem lies and where we can help you find an answer. Here's an example of what we are asking for.

 

[quest]

Hi, there might be a slight language problem. We do not need to see a screenshot of just the result.

We also need to see a screenshot of the form in design view showing us the actual rule you wrote for the conditional formatting. That's where the problem lies and where we can help you find an answer. Here's an example of what we are asking for.

View attachment 122132

sorry didn't understand that here is the screenshot

 

[CJ_London]

Aside from the fact you are not specifying a back color, perhaps the control back color is set to transparent

 

[quest]

Aside from the fact you are not specifying a back color, perhaps the control back color is set to transparent

how to see what is default color for other fields without formatting so i can apply that color.

 

[mike60smart]

how to see what is default color for other fields without formatting so i can apply that color.

Can you upload a zipped copy of the database?