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
However, you could use conditional formatting, and that would allow you to
set the background to some color (such as very gray) for those controls
that
you don't allow editing for (and, then you set/change the enabled property
of that control).
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@[EMAIL PROTECTED]
|
