Global change to all form controls in MS Access
Posted on 2011-05-06
I have devised a way of having a parameterised method of changing the Form Detail and Header background colours for all forms in my database. I store these values in a table and these can be changed by the user, and these values are referred to by VBA each time a form is opened.
Is there a way of changing the background, font, border etc of each control in a form, without having to individually go to each control's properties? For example, is there a global method for each form, or a way of looping through each control as the form is opened?