Conditional formating in a footer of a form

[jeanulrich00]

Hi

I have a continuous form and one field is % [Portion]

In the form footer I hadd a text box with a formula = sum([Portion])

I have try to add conditional formating on that control that would put
the background in red when the total is not equal to 1 (100%)

If the form contain just one record [Portion] = 100% and the
background of the control say white

If ther is 2 or more records, the background of the control change to
red even if the total of records equal 100%

I don't realy understand what is wrong.

It seams that the conditional formating is applied only on the first
record

Thanks to help me

 

[Al Campagna]

Jean,
What is the Conditional Formatting statement that you used?
I'll assume that the calculated value is .10 (for 10%) or 1.0 (for 100%)
The calculated field is named SumOfPortion.
Cond1 = FieldValue | is less than | 1 ' (Red)
Cond2 = FieldValue | is equal to | 1 '(Green)

You probably should also show Red if the SumOfPortion is greater than
100% too.
Cond3 = FieldValue | is greater than | 1 '(Red)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Al Campagna]

Jean,
Also, for now, make all your Conditional Formatting changes in Form
Design Mode... not in Form Preview.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."