Re calculation during scrolling (1 Viewer)

is it possible to stop access report for recalculating fields during scrolling to view report smoothly during scrolling

A report wouldn't recalculate, a report is effectively static data?

Do you mean a form or datasheet ?

Minty said:

A report wouldn't recalculate, a report is effectively static data?

Do you mean a form or datasheet ?

Click to expand...

when i scroll down opened report scrolling does not occure smoothly it just looks like report is re calculating
i am talking about report (report view)that is made on query

the report starts displaying data once there is enough to display. The query will to continue to create the dataset in the background. The behaviour you are describing implies the query is slow.

Suggest open the query and time until the recordcount is displayed at the bottom - this is how long it takes to calculate.

If it is slow, then the only thing you can do is to speed it up. Without knowing the complexity of your query and the structure of your tables it is difficult to advise.

Slow queries may because of a slow network, use of domain functions, use of subqueries, lack of indexing in tables, using * as the initial character in Like criteria, using tables across multiple databases among others