Results 1 to 2 of 2
2008-11-06, 07:29 #1
- Join Date
- May 2008
- Thanked 0 Times in 0 Posts
continuous form - conditional formating (2000)
I have an option group with two option buttons in it. I would like to have the two option buttons become invisible (or the entire group) when a check box is unchecked on a record by record basis. I would also like it to be visible when the check box is checked. Conditional formating doesn't seem to be working. The form is in the continuous form view.
2008-11-06, 07:46 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: continuous form - conditional formating (2000)
You have a problem here.
You can't use conditional formatting to hide a control, moreover it doesn't work for option groups or option buttons, only for text boxes and combo boxes.
VBA code won't do what you want either, for hiding the option group using code will affect ALL records in a continuous form, there is no way to do so for specific records only.
If you want to continue using a continuous form, the best you can do (I think) is to replace the option group with a combo box, and to use conditional formatting to disable this combo box when the check box is clear and to enable it when the check box is ticked. This will work on a record-by-record basis.