Conditional Formating not working...

[Lester Lane]

Hi, I have Conditional Formatting on 4 fields in a subform. 2 are in
Details and 2 in the form footer. They show the Profit/Loss and
percentage, and their totals. I have set them to be RED if negative.
They were all configured at the same time yet one field insists on
remaining red. This is the total of the percentage (field a/field b)

I notice that when the main form changes its selection the subform
goes blank for a little while whilst it is populating but the field in
question shows #Num! error for a split second. This is red. What is
going on and when does Conditional formatting fit into the events on a
form? I've even tried adding an IIf IsNull on field b to the calc to
make sure it only calcs when data is present but it still shows #Num!
when the data is being pulled in.

Any ideas most welcome.

 

[Lester Lane]

Hi, I have Conditional Formatting on 4 fields in a subform.  2 are in
Details and 2 in the form footer.  They show the Profit/Loss and
percentage, and their totals.  I have set them to be RED if negative.
They were all configured at the same time yet one field insists on
remaining red.  This is the total of the percentage (field a/field b)

I notice that when the main form changes its selection the subform
goes blank for a little while whilst it is populating but the field in
question shows #Num! error for a split second.  This is red.  What is
going on and when does Conditional formatting fit into the events on a
form?  I've even tried adding an IIf IsNull on field b to the calc to
make sure it only calcs when data is present but it still shows #Num!
when the data is being pulled in.

Any ideas most welcome.

Too boring or too complicated?! No lookin since posted. I've also
noted that if the first record is positive and therefore blank that
the second row of data remains black even if negative. Does
conditional formatting only work on the first record? Is it suitable
for continuous forms, if not what is please?

 

[Lester Lane]

Too boring or too complicated?!  No lookin since posted.  I've also
noted that if the first record is positive and therefore blank that
the second row of data remains black even if negative.  Does
conditional formatting only work on the first record?  Is it suitable
for continuous forms, if not what is please?

I've fixed this myself thanks - so here is the answer in case anyone
else has a similar issue. Simply set the Conditional Formatting to
change red if negative but most importantly set up another row to make
it black if positive. Seems simple when you know how. It seems that
in a continuous form the next record starts with the format of the
previous and not what was set in the design of the form.