Hiding different controls on each row of a form

  • Thread starter Thread starter Steve Neufeld via AccessMonster.com
  • Start date Start date
S

Steve Neufeld via AccessMonster.com

I have a form that has 3 checkboxes per row. I want to hide two of the
checkboxes based on the contents of another field on the same row. This
would be different for each row. Is there a way to do this? So far all I
have been able to do is hide the same checkboxes on every row. If I tab to
a different row, they all change together. I want them all to stay like
they are supposed to...
Thanks!
 
I have a form that has 3 checkboxes per row. I want to hide two of the
checkboxes based on the contents of another field on the same row. This
would be different for each row. Is there a way to do this? So far all I
have been able to do is hide the same checkboxes on every row. If I tab to
a different row, they all change together. I want them all to stay like
they are supposed to...
Thanks!
Click to expand...

In A2000 and later, you can use "Conditional Formatting" to do this.
Select the textboxes and choose Conditional Formatting from the Format
menu item in form design view.

John W. Vinson[MVP]
 
Thanks John, but this didn't work. I am working with checkboxes, not
textboxes, and A2000 doesn't seem to use conditional formatting with
checkboxes.

To be more precise, I have a form using the "Continuous Forms" property. I
have 3 checkboxes and 1 textbox (and others that don't need mentioning). I
want to hide 2 of the checkboxes based on the contents of the textbox.
This will be different on each row. For instance, in row 1, textbox1 may
contain "A". In that case, I will want to hide checkboxes 2 & 3. But in row
2, textbox1 may contain "B". In that case, I would want to hide checkboxes
1 & 3. Hope that helps!

Thanks!
Steve
 
Thanks John, but this didn't work. I am working with checkboxes, not
textboxes, and A2000 doesn't seem to use conditional formatting with
checkboxes.

To be more precise, I have a form using the "Continuous Forms" property. I
have 3 checkboxes and 1 textbox (and others that don't need mentioning). I
want to hide 2 of the checkboxes based on the contents of the textbox.
This will be different on each row. For instance, in row 1, textbox1 may
contain "A". In that case, I will want to hide checkboxes 2 & 3. But in row
2, textbox1 may contain "B". In that case, I would want to hide checkboxes
1 & 3. Hope that helps!
Click to expand...

I know of no way to do that... *with checkboxes*.

However, you can bind a Textbox to a Yes/No field and program its
Click event to toggle it from true to false; use a format property of

"";"X";"";""

to display True (-1) as an X, anything else as blank. You can then use
the conditional formatting on the textbox.

John W. Vinson[MVP]
 
Back
Top