Making controls invisible dynamically

[Laurel]

I have a multi-row form where I want one of the columns to be a bound
checkbox if the data is one thing, and a bound text box if the data is
something else. If "conditional formatting" allowed me to set the controls
to visible/invisible that would be great, but it doesn't. Anything else I
can think of, I believe, would change the presentation of all the rows on
the form, not just the current one. Does anyone have any suggestions?

 

[Albert D. Kallal]

You can set the visible/invisible property..and you are 100% correct that
the setting will apply to all controls.

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

 

[Laurel]

I'm not just enableing, I want to sent the invisible property, so different
controls, sitting in the same place, are visible, depending on other data in
the row. If the same thing were visible in all of the rows, it would
represent inaccurate data. The reason I have this weird problem, is that
I'm trying to mimic exactly an attendance sheet for a public school system.
When they do it by hand, they enter a check, or "NPR" or "S". So I don't
want the checkbox to show up if NPR or S are present. The data comes from
different columns, so it needs to be in different controls.