Conditional Formatting

In my data base I am asking to color code field "A" in green if the amount
is less than filed "B". I have also asked for field "A" to highlight blank
records in purple. Can you ask for different colors and different criteria of
the same field? I tried doing this and it worked for only the purple
expression and highlighted in green the oppposite field of my expression? I
hope this make sense?

--
Merlin

Using Conditional Formatting from the Format Menu you can have three
different conditions with associated colors plus a Default Color for a given
control.

If the form is a Single View Form you can have as many conditions as desired,
using code in the appropriate control's AfterUpdate event as well as in the
Form_Current event.

What exactly is your situation?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201002/1

I am working in reports. I do not know how to ask for the difference between
two columns of numbers. I want to show when one column of numberes is larger
that the other by color coding it. When I ask this I get the opposite result.
see example:
Per occurance amount
--
Merlin


"Linq Adams via AccessMonster.com" wrote:

Using Conditional Formatting from the Format Menu you can have three
different conditions with associated colors plus a Default Color for a given
control.

If the form is a Single View Form you can have as many conditions as desired,
using code in the appropriate control's AfterUpdate event as well as in the
Form_Current event.

What exactly is your situation?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201002/1

.

here is my situation:
In my report I am asking to color code a field in the "Per Occurance Amount"
column when the dollar amount is less than the "Contract Per Occurance
Amount" column. When I ask this in my conditional formatting box it colors a
box in the "Per Occurance Amount" column when it is greater than the
"Contract Per Occurance Amount" column. In other words I get the opposite
result of my question.
--



"Linq Adams via AccessMonster.com" wrote:

Using Conditional Formatting from the Format Menu you can have three
different conditions with associated colors plus a Default Color for a given
control.

If the form is a Single View Form you can have as many conditions as desired,
using code in the appropriate control's AfterUpdate event as well as in the
Form_Current event.

What exactly is your situation?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201002/1

.

"Linq Adams via AccessMonster.com" wrote:

Using Conditional Formatting from the Format Menu you can have three
different conditions with associated colors plus a Default Color for a given
control.

If the form is a Single View Form you can have as many conditions as desired,
using code in the appropriate control's AfterUpdate event as well as in the
Form_Current event.

What exactly is your situation?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201002/1

.