conditional formatting of a form

[Newbie_Sashi]

Hi,
I am attempting to format a continuous form with multiple conditions.
I am using an unbound text field and thereby formatting the back ground of
the entire form.
My condition works like, if currency = USD and amount > 1000 then color = red.
I have tried using the conditional format, but if i give these as 2
conditions, access uses the OR condition i.e the system reads it as currency
= USD or Amount > 1000 whereas i need the system to use the AND condition.
Pls help.

Newbie

 

[Dirk Goldgar]

Hi,
I am attempting to format a continuous form with multiple conditions.
I am using an unbound text field and thereby formatting the back ground of
the entire form.
My condition works like, if currency = USD and amount > 1000 then color =
red.
I have tried using the conditional format, but if i give these as 2
conditions, access uses the OR condition i.e the system reads it as
currency
= USD or Amount > 1000 whereas i need the system to use the AND condition.
Pls help.

Try a single condition with an expression similar to this:

([currency] = "USD") And ([amount] > 1000)