Form Keeps calculating - wont stop

  • Thread starter Thread starter Steve W
  • Start date Start date
S

Steve W

Hi I have just upgraded to Access 2003 in the office 2003
pack from access 2003 in the office XP pack.
Im having trouble with some of my forms.
For no reason the form shows correct and the fields
calculate out ( date fields with conditional formating -
changing colours after set amount of days )but when I
change to Data sheet view the form starts calculting and
just wont stop untill I click on refresh 2 times then the
results of the calc shows correct. Any help please or
shall I just go back to using office XP the pages work
fine with this version.
Any help most welcome

Steve
 
I had a problem similar to this when I upgraded from 97.
the only way I could get the form to stop calculating was
to click off Access on to the desktop. And I wasn't
performing any "calculations"... I'd like to see if
anyone else has found a solution.
 
Sarah
I have taken the calculations of the form and calculated
within the Query and made the form look to the query for
the data and then it all worked fine no recalc over an
over again. I checked the form calculations and can see
no problem there. It works now. Any Ideas why?

Steve
 
Allen
Thanks so much for this information it is excactly whats
going on here.
Do you know if Microsoft is going to fix this problem.?
I have wasted 3 days trying to fix it. Its so frustrating
but now I know it can be duplicated and is a fault I will
stop trying and stop blaming myself for poor code.

Thank you again

Steve W
-----Original Message-----
Take a look at:
Conditional formatting flaws
at:
http://allenbrowne.com/bug-05.html

You might experiment with trying to set the
Click to expand...
ConditionalFormatting conditions
 
Hi Steve.

I (and others) have brought it to their attention, but trying to get it
fixed is another issue. Don't hold your breath.
 
Allen

Thanks for your post. Saved me a bunch of time

I ran into this problem but my observations are a little different than what yours. I have calculated text fields with conditional formatting that work fine under Access 2002 but get into the loop you describe when run with Access 2003

Any thoughts

Tom
 
Back
Top