Button hidden in Continuous form depending on specific record value

  • Thread starter Thread starter brunogrd
  • Start date Start date
B

brunogrd

Hi everyone,

I've created a continuous form and I'm trying to display (or hide) a control
(text field or button) depending on the result of a combo box entry in each
individual record. Up to this point I've been able to create the code that
will display or hide the control but it does so for each record on the form.
Would you know a way to do it on a record by record basis??

Thanks,

Bruno.
 
While it may look as though you've got, say, 20 buttons on the form when
there are 20 rows of data, in actual fact there's only a single button,
repeated 20 times. That means that referring to it refers to all of them,
meaning that it's an all-or-nothing proposition.
 
I certainly have a lot of continues forms where I set the controls 'enabled'
property on/off. While this actually makes all instances of the control go
disabled, I actually find this works quite well. I mean, when you move
to the next row, those columns that you enable, or disable can then
be set. So, you could set the controls visible property as you move
the cursor up/down through the

In fact, I actually PREFER the above behavior, as then during
data entry it is VERY easy to see that the column in question
is enabled.

In place of a VERY HARD TO READ checkerboard pattern of enabled, and
disabled boxes,
, you get a very nice enable/display view as I move the cursor up /down.

I have uploaded a gif animation of me navigating in a form, both of the two
screen shots will give you an idea of how this looks.

http://www.members.shaw.ca/AlbertKallal/HideColumn/index.htm
 
brunogrd said:
I've created a continuous form and I'm trying to display (or hide) a control
(text field or button) depending on the result of a combo box entry in each
individual record. Up to this point I've been able to create the code that
will display or hide the control but it does so for each record on the form.
Would you know a way to do it on a record by record basis??
Click to expand...


I think the closest you can get is to use Conditional
Formatting to enable/disable a text box.
 
Back
Top