I have a form with around 50 text/combo-boxes that (apart from one field) have the Font ForeColor set to 11250603 Grey on load using VBA
I want each cell, on selection (or GotFocus), to change the ForeColor to vbBlack. I have done it the field by field but that is repetitive and clumsy. I would like to use a succinct piece of code perhaps at Form level and/or in a module to do the same task but haven't found anything that suits Access.
The closest I have come to identifying a possible route is by using DirectCast() but I am unfamiliar with it and its parameters.
If someone could point me to a piece of code or YouTube video or even a text that I could adapt, it would be much appreciated.
I want each cell, on selection (or GotFocus), to change the ForeColor to vbBlack. I have done it the field by field but that is repetitive and clumsy. I would like to use a succinct piece of code perhaps at Form level and/or in a module to do the same task but haven't found anything that suits Access.
The closest I have come to identifying a possible route is by using DirectCast() but I am unfamiliar with it and its parameters.
If someone could point me to a piece of code or YouTube video or even a text that I could adapt, it would be much appreciated.