Include "hide control" feature Continuous Forms
Currently on Continuous Forms, the developer can enable/disable, along with a few other functionality items relating to conditional formatting. At the moment, there is no "hide/unhide" feature to allow developers to display or not display controls based upon values of a particular row of data. There are ways to do it, but only in a very convoluted way, and very confusing when having to manage the code. Please include this functionality for continuous forms!
Adrian Bell (MVP) commented
I agree. Disabling the control and hiding it (Setting .Visible to False) are not the same thing.
The latter is certainly something I believe would be a good addition.
When trying to change the Visible property of a control during the "OnPaint" event in a continuous form (Access 2016), you get the following message :
You can't change the value of this property in the OnPaint event
So no, it is not possible to do this now using the "OnPaint" event in a continuous form. This is still an item which should be included in future versions of Access.
It's possible to do now using the "OnPaint" event.
Hi Crystal - conditional formatting does not give developers the ability to hide or make a control visible based on the value of the current record.
use conditional formatting