Conditional Formatting Help Please

[TotallyConfused]

I have a datasheet form where I had several conditions depending on a couple
of fields one of the fields is numeric. I have been asked to add another
number field and a condition of changing back color . When opening form the
last condition is being applied even though the field associated with this
condition is blank. How can I fix this? Thank you for any help you can
provide.

 

[Linq Adams via AccessMonster.com]

You're not the only one who's totally confused! You really need to give us a
few more specifics if anyone is to help you. Names of the fields involved,
what you have in the Conditional Formatting of which fields, stuff like that.

 

[TotallyConfused]

Okay - thank you for responding. My form is a subform with multiple fields.
The fields the conditions are set to are:

Company - [Company] = "Print" (turns backcolor green and font is greyed)
Flag - [Paid] = 1 or 2 or 3 (turns backcolor yellow and font is greyed
Paid - [Flag] = True (turns backcolor blue and font is greyed)

My fields are: Flag, Paid, Company, Contact, Date Sent, Date Received

I have tried putting the conditional formatting in different order and I am
still getting rows highlighted where Flag has no entry of 1, 2 or 3 and rows
with 1, 2 or 3 are highlighted.

I hope this help you help me. Thank you.

 

[Linq Adams via AccessMonster.com]

I'm sorry, I'm still having trouble following. I take

Paid - [Flag] = True (turns backcolor blue and font is greyed)

to mean that the "Paid" control is Conditionally Formatted to blue/grey if

[Flag] = True.

But you then speak of

"I am still getting rows highlighted where Flag has no entry of 1, 2 or 3"

So, is [Flag] a True/False field or can it hold 1, 2 or 3?

I also assume that the condition for these two formats are set "Expression
Is"

Flag - [Paid] = 1 or 2 or 3 (turns backcolor yellow and font is greyed
Paid - [Flag] = True (turns backcolor blue and font is greyed)

Is this correct?

Finally,

[Paid] = 1 or 2 or 3

won't work. The correct syntax would be:

[Paid] = 1 or [Paid] =2 or [Paid] =3

 

[TotallyConfused]

Thank you very much Linq. I am sorry for not being more specific. I am
learning and will be more specific and detailed with my questions.

The syntax you provided corrected the problem.

One more question please, in Conditional Formatting can you nest a
condition? If not, since you can only set 4 conditions via Conditional
Formatting can you set a couple more conditions via code? Thank you once
again.

I'm sorry, I'm still having trouble following. I take

Paid - [Flag] = True (turns backcolor blue and font is greyed)

to mean that the "Paid" control is Conditionally Formatted to blue/grey if

[Flag] = True.

But you then speak of

"I am still getting rows highlighted where Flag has no entry of 1, 2 or 3"

So, is [Flag] a True/False field or can it hold 1, 2 or 3?

I also assume that the condition for these two formats are set "Expression
Is"

Flag - [Paid] = 1 or 2 or 3 (turns backcolor yellow and font is greyed
Paid - [Flag] = True (turns backcolor blue and font is greyed)

Is this correct?

Finally,

[Paid] = 1 or 2 or 3

won't work. The correct syntax would be:

[Paid] = 1 or [Paid] =2 or [Paid] =3