Access 2013 Forms Slow

(Update: 11 Aug 2016 – The best thing I have tried to date is by downloading and running the Microsoft .NET Framework Repair Tool .  You may need to restart your PC after using this.  I saved a copy of the repair tool file to an easy to find folder on my hard disk because I have to re-run it from time to time to re-apply the fix.  I’ve been trying this fix for several months and so far it has always fixed the problem, albeit until the next time!

(Plea to Microsoft: Please, please fix this – Access is a brilliant small scale database platform that remains pretty much unequalled in it’s class!) 

I recently had an issue with MS Access 2013 and tabbed controls where clicking on a tab would make MS Access hang for about 5 seconds.  I’m using MS Windows 8.1 and MS Office 365 with MS Access 2013.

An example is where I open a form that has a tab control on it.  In this case, my tab control had 4 tabs.  After opening the form,  when I clicked on another tab, MS Access hung for about 5 seconds before showing the tab.  It didn’t matter which tab I clicked on, I always had to wait 5 seconds for it to show.

Another symptom could be found when designing an MS Access database.  The Properties window, which is also tabbed takes an age to switch tabs and you can even see the screen redrawing itself – it’s that slow!

Workaround

This issue has come and gone by itself a few times, and after lots of Googling, I finally found a work around.

From within MS Access, click File, Options, Current Database, then down to the setting called “Use Windows-themed Controls on Forms”.  Un-check this box.

When ‘checked on’ this setting gives the MS Access interface a more rounded look, but clearly has a problem when activated.

Hope that helps someone who has been as equally tortured by this bug as me.