sign in | join about | help | sitemap
Connecting Tech Pros Worldwide
Cindy K.'s Avatar

Conditional Formatting - looping error


Question posted by: Cindy K. (Guest) on November 12th, 2005 04:41 PM
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!
3 Answers Posted
Steve Jorgensen's Avatar
Guest - n/a Posts
#2: Re: Conditional Formatting - looping error

On 19 Nov 2003 16:46:35 -0800, Join Bytes! (Cindy K.) wrote:
[color=blue]
>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![/color]

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.'s Avatar
Guest - n/a Posts
#3: Re: Conditional Formatting - looping error

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 <nospam@nospam.nospam> wrote in message news:<b2iorvcune26semlpcsn8lnlooouaepimq@4ax.com>...[color=blue]
> On 19 Nov 2003 16:46:35 -0800, Join Bytes! (Cindy K.) wrote:
>[color=green]
> >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![/color]
>
> 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.[/color]
Steve Jorgensen's Avatar
Guest - n/a Posts
#4: Re: Conditional Formatting - looping error

On 20 Nov 2003 06:37:58 -0800, Join Bytes! (Cindy K.) wrote:
[color=blue]
>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.
>[/color]

Good plan, IMO.
 
Not the answer you were looking for? Post your question . . .
196,916 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 196,916 network members.
Post your question now . . .
It's fast and it's free

Popular Articles

Top Community Contributors