Conditional Formatting - looping error

[Cindy K.]

I'm using Access 2000, and have a continuous form with subtotals on
the bottom of the form. The formula for the subtotal is
=[unbFull]-[calcSum]

The calcSum field is simply a Sum of a currency field in the form.
The unbFULL field is in the report header, filled when the form is
opened through the OpenArgs property.

I tried putting a conditional format on the field, stating that if the
field value was greater than 0 to bold the field and shade the
background.

Sometimes it works like a charm - and at other times it appears to go
into an unending loop.. The field blinks repeatedly - the system is
frozen while it's blinking away...

I read in an earlier post someone had a similar problem when working
with a subform. No solution was found - this is similar but without
the subform issue. I've checked Microsoft's KB with no luck. Anyone
seen this behaviour? Thanks in advance!

[Steve Jorgensen]

On 19 Nov 2003 16:46:35 -0800, ck****@rochester.rr.com (Cindy K.) wrote:

I'm using Access 2000, and have a continuous form with subtotals on
the bottom of the form. The formula for the subtotal is
=[unbFull]-[calcSum]

The calcSum field is simply a Sum of a currency field in the form.
The unbFULL field is in the report header, filled when the form is
opened through the OpenArgs property.

I tried putting a conditional format on the field, stating that if the
field value was greater than 0 to bold the field and shade the
background.

Sometimes it works like a charm - and at other times it appears to go
into an unending loop.. The field blinks repeatedly - the system is
frozen while it's blinking away...

I read in an earlier post someone had a similar problem when working
with a subform. No solution was found - this is similar but without
the subform issue. I've checked Microsoft's KB with no luck. Anyone
seen this behaviour? Thanks in advance!

As I recall, this is one of many bugs in Access 2000 that do not occur in
Access 2002. Personally, I fond 2000 too buggy to bother with. Upgrade if
you can.

[Cindy K.]

Alas, not a solution for this customer yet. I'm keeping some of their
97 Access databases IN 97 though... that's for sure!! Thanks Steve.

Steve Jorgensen <no****@nospam.nospam> wrote in message news:<b2********************************@4ax.com>. ..

On 19 Nov 2003 16:46:35 -0800, ck****@rochester.rr.com (Cindy K.) wrote:

I'm using Access 2000, and have a continuous form with subtotals on
the bottom of the form. The formula for the subtotal is
=[unbFull]-[calcSum]

The calcSum field is simply a Sum of a currency field in the form.
The unbFULL field is in the report header, filled when the form is
opened through the OpenArgs property.

I tried putting a conditional format on the field, stating that if the
field value was greater than 0 to bold the field and shade the
background.

Sometimes it works like a charm - and at other times it appears to go
into an unending loop.. The field blinks repeatedly - the system is
frozen while it's blinking away...

I read in an earlier post someone had a similar problem when working
with a subform. No solution was found - this is similar but without
the subform issue. I've checked Microsoft's KB with no luck. Anyone
seen this behaviour? Thanks in advance!

As I recall, this is one of many bugs in Access 2000 that do not occur in
Access 2002. Personally, I fond 2000 too buggy to bother with. Upgrade if
you can.

[Steve Jorgensen]

On 20 Nov 2003 06:37:58 -0800, ck****@rochester.rr.com (Cindy K.) wrote:

Alas, not a solution for this customer yet. I'm keeping some of their
97 Access databases IN 97 though... that's for sure!! Thanks Steve.

Good plan, IMO.