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!
pflipper
shared this idea
6 comments
-
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.
-
pflipper
commented
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.
-
Anonymous
commented
It's possible to do now using the "OnPaint" event.
-
pflipper
commented
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.
-
Crystal
commented
use conditional formatting