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!
Ben Sacheri commented
Great request! Having this feature would allow me to build a "survey" interface where each row could be a different question type. One question could be fill in the blank, the next could be pick a radio button, and the next question row could be checkboxes. I built a database schema for this years ago and got stuck on this part. Without tons of programming the solution was to use a single record (not continuous) view but that hurt the user experience of being able to see multiple responses at once.
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