Make Controls Invisible in a continuous form

[Guest]

I am using a continuous form that contains multiple records. Is it possible
to set conditions so that a text box is invisible or visible depending on the
value contained in each record? This is easy when not using a continuous form
but I could not figure out how to do this for a continuous form.

 

[Rob Parker]

Use Conditional Formatting; it will let you do this - with a lttle bit of
trickery. Conditional Formatting does not offer an option to change a
control's visiblity, but you can set the foreground and background colours
to those of your form's background, and disable the control. This will give
the same appearance in a continuous form.

HTH,

Rob

 

[Guest]

Thanks for your suggestion. I am currently using conditional formatting but I
was hoping that there was another way.

 

[Albert D.Kallal]

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