Dynamic Conditional Formatting on Continues SbuForm

[rkr]

I have a sub-form with a Textbox, combobox, and a hidden Textbox. I am trying to figure out how to hide the combobox if the value in the hidden textbox is 0.



So far, I have tried condotional formatting, however, that only allows you to change the color and Enable property.

I tried finding a way to loop through the controls using code such as below. But the issue is here, is I need the instance of the control, and that I can't find.

'    Dim iType As Integer
'
'    For Each ctl In Me!frm_Part_Management_Subform.Controls
'        If ctl.Name = "txt_subform_Attribute_Type" Then
'            iType = ctl.value
'        End If
'
'        If ctl.Name = "cmb_Part_Attribute_Value_ListItems" Then
'            If iType = 0 Then
'                ctl.Visible = False
'            Else
'                ctl.Visible = True
'            End If
'        End If
'    Next ctl

[aytee111]

You can refer to the control directly, there is no need to loop thru all the controls - Me!controlname
If Me!hiddentextbox=0 Then
...hide the combobox
End If
Note that if this is a continuous form this won't work as expected as changes will be made to every row.

[Missinglinq]

As aytee111 suggested, doing this, thru code, will format the Control on all Records, not just the current one! For this kind of thing, you must use Conditional Formatting.

Don't have time to test this, but to hide the Combobox, I think you need to use Conditional Formatting to set the Back Color and the Fore Color to the same color as the underlying Form section...making it, in essence, 'invisible.'

Clunky, but I think it's the only option available to you.

Linq ;0)>

[rkr]

Yes, it will change all of them and that is exactly what I do not want.

There has to be a way to reference that single instance, without using conditional formatting. Setting them both to the same color, doesn't really make it invisible. You can still see parts of it.

Anyways, I will mark this as not possible.

[aytee111]

You could set it to enabled=No, which will grey the box out. Maybe better than leaving it exposed.

[rkr]

That is what I have done. so that the tab key skips it.