none
Report and calculations when scroll/roll RRS feed

  • Question

  • Greetings Access for Developers,  I've a complicated Report, in report view (not print preview).  When one scrolls or rollers - the many unbound field calculations re-fire - - - and depending on where one stops (going up/down) they may or may not catch up.

    When they don't catch up they display #Size! or #Type!

    The report size is about max at about 21 x 21 and there are 2 reports and a bunch of cascading calculations in unbound textboxs involving DLookUp and such - -

    It's pretty quirky.  I can understand a continuous Report could have a great area off screen such that calculations don't fire until they are brought in view....but this is just a few inches and everything is re-firing.

    It is going to be a big effort to put all the calcs into a master query in order to use bound text boxes.  Is there anything that can be done as it is now? 

     

    Thursday, February 21, 2019 10:48 PM