Slow speed of programmatically setting control properties
Posted on 2009-04-23
I have recently converted a system from AccessXP to Access 2007. One of my forms periodically displays a tab which contains 120 labels (or text boxes) for which properties (NOT values) may need to dynamically changed when other values on the form are changed. The properties most commonly affected are BackColour, BackStyle, BorderStyle and Tab. Using AccessXP, the properties of all 120 controls could be changed in less than a second. With Access 2007, the same process takes 10 to 13 seconds. Has anyone a suggestion as to why this should be or, better still, some technique for making the process MUCH quicker in Access 2007.