Some of us are still using Access 2002 front ends with SQL Server back ends. I have been looking for the solution to the problem for about two months and finally got a hint that the page xx of page yy could be a problem. It was.
Bottom line, old software does not have to die.
Microsoft Access report takes extremely long time. Message on bottom of screen is "Formatting Report: Press Ctrl-Break to Stop"
Solution is to remove the formatting of the number of pages (Page xx of yy).
Instead of
="Page " & [Page] & " of " [Pages]
use
="Page " & [Page]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.