June 10, 200817 yr I'm looking for a way to hide or show radio buttons based on whether two text boxes have data in them or not. So far, I've tried conditional formatting for the buttons, but this only hides the text, while the buttons themselves stay showing. I've also tried the 'trick' with a single row, self-relational portal containing them. The portal does hide and show when I change the value of the text boxes, but the portal only shows the radio option chosen, not the buttons themselves (i.e. when I choose a different radio button, the value in the portal changes). Is there any way to make the buttons completely 'invisible'? I would like to make it so that when neither text box has text in it, the buttons are invisible. When data is entered in the first box, it becomes visible, and if data is entered in the second box, it becomes invisible again. Ideally, the user would be unable to enter anything into the second box at all until there is something in the first one. Thanks.
June 10, 200817 yr The portal trick should work. Try creating a stored calc as such. Case ( not IsEmpty (field1) and IsEmpty (field2); pkYourKEY ) Then create the self join from your pkYourKey to the new calc using the portal visibility method.
Create an account or sign in to comment