conditional formatting form using OR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with the following fields: Address1, Address2, and
CurrentAddress.

I would like to use conditional formatting that will convert the font for
CurrentAddress if it does not equal Address1 OR Address2.

For some reason, the conditional formatting doesn't seem to work properly.
It's almost like Access is using AND instead of OR, so I'm not sure how to
use OR.

Thanks in advance for your help!!
 
I'm using the following conditional formatting for CurrentAddress--

Condition 1: Field value is not equal to [Address1]
Condition 2: Field value is not equal to [Address2]

When I do this, the font will change when CurrentAddress is not equal to
either Address1 or Address2. What I really want is for the CurrentAddress
font to change when both Address1 AND Address2 don't equal CurrentAddress.
Basically, I just want to have the visual alert whenever CurrentAddress is
different from both Address1 and Address2.

I also tried to input Condition 1: Field value is not equal to [Address1]
OR [Address2], but nothing happened.


Thanks!
 
Have you tried AND in the last expression you used?
--
Maurice Ausum


Emmett L. said:
I'm using the following conditional formatting for CurrentAddress--

Condition 1: Field value is not equal to [Address1]
Condition 2: Field value is not equal to [Address2]

When I do this, the font will change when CurrentAddress is not equal to
either Address1 or Address2. What I really want is for the CurrentAddress
font to change when both Address1 AND Address2 don't equal CurrentAddress.
Basically, I just want to have the visual alert whenever CurrentAddress is
different from both Address1 and Address2.

I also tried to input Condition 1: Field value is not equal to [Address1]
OR [Address2], but nothing happened.


Thanks!


Maurice said:
Hi Emmet,

What are the settings you used for the conditional formatting?
Click to expand...
Click to expand...
 
Yep. Tried that, too. It seems that Access is reading only one of the
conditions, rather than both.

Maurice said:
Have you tried AND in the last expression you used?
--
Maurice Ausum


Emmett L. said:
I'm using the following conditional formatting for CurrentAddress--

Condition 1: Field value is not equal to [Address1]
Condition 2: Field value is not equal to [Address2]

When I do this, the font will change when CurrentAddress is not equal to
either Address1 or Address2. What I really want is for the CurrentAddress
font to change when both Address1 AND Address2 don't equal CurrentAddress.
Basically, I just want to have the visual alert whenever CurrentAddress is
different from both Address1 and Address2.

I also tried to input Condition 1: Field value is not equal to [Address1]
OR [Address2], but nothing happened.


Thanks!


Maurice said:
Hi Emmet,

What are the settings you used for the conditional formatting?
--
Maurice Ausum


:

I have a form with the following fields: Address1, Address2, and
CurrentAddress.

I would like to use conditional formatting that will convert the font for
CurrentAddress if it does not equal Address1 OR Address2.

For some reason, the conditional formatting doesn't seem to work properly.
It's almost like Access is using AND instead of OR, so I'm not sure how to
use OR.

Thanks in advance for your help!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top