conditional formatting of a form

  • Thread starter Thread starter Newbie_Sashi
  • Start date Start date
N

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
 
Newbie_Sashi said:
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.
Click to expand...


Try a single condition with an expression similar to this:

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