Enable/Disable button on Continuous Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can a button on a continuous subform be enabled disabled on a row by row
basis? I've seen posts re lebans.com but that changes values on a textbox
which is not really what I want.

Thanks
Allen
 
Allen said:
Can a button on a continuous subform be enabled disabled on a row by row
basis? I've seen posts re lebans.com but that changes values on a textbox
which is not really what I want.
Click to expand...


Enable/Disable is available in Conditional Foramtting.
 
Hi Marshall

If I click on my button and go to the format menu 'conditional formatting'
is greyed out?
 
Doh - Do you mean use a text box as a button and use the text boxes
enable/disable?

Do I understand correctly?

Thanks for the reply
Allen
 
Well, you figured it out even though I forgot that CF isn't
available for buttons.

Be sure to set the text box's control source to an
expression like ="button caption", which will also prevent
users from typing in the text box.
 
whoop de la la


will try and post result here

thanks marsh

Marshall Barton said:
Well, you figured it out even though I forgot that CF isn't
available for buttons.

Be sure to set the text box's control source to an
expression like ="button caption", which will also prevent
users from typing in the text box.
--
Marsh
MVP [MS Access]


Allen said:
Doh - Do you mean use a text box as a button and use the text boxes
enable/disable?

Do I understand correctly?
Click to expand...
Click to expand...
 
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
 
Back
Top